Page 73 - Excel 2013 All-in-One For Dummies
P. 73
Exercising Your Options 55
Option
Editing Options
Cut, Copy, and Paste
Image Size and Quality Print
Chart Display
Display Options for This Workbook
Display Options for This Worksheet
Formulas
When Calculating This Workbook
General
Data
Lotus Compatibility
Lotus Compatibility Settings
What It Does
Changes the way you edit the worksheets you create
Changes the way worksheet editing involving cutting, copying, and pasting to and from the Clipboard works
Controls how an image’s data is used in a worksheet
Controls whether high or regular quality is used for the graphic images in the printed worksheet
Controls how Excel deals with the charts you add to a worksheet
Determines how various elements (from recently used workbooks in the Backstage view to ruler units, the presence of the Formula bar, ScreenTips, and com- ments in the worksheet) appear onscreen
Sets display options for the current workbook open in Excel
Sets display options for the currently selected work- sheet in the workbook open in Excel
Determines how Excel deals with calculating sophisti- cated formulas in the worksheets in your workbook
Sets calculation parameters for the workbook open in Excel
Controls various all-purpose options, including such diverse options as the workbook files that you want opened when Excel launches, how your workbooks appear on the web, and the creation of custom AutoFill lists
Controls how Excel copes with operations involving large amounts of data and the new Data Model
Sets general Lotus 1-2-3 compatibility in Excel 2013
Sets Lotus 1-2-3 compatibility for a particular work- sheet in the workbook open in Excel
The various and sundry options in these 14 sections of the Advanced tab actually fall into 4 somewhat distinct areas: options for editing in the work- sheet; options controlling the screen display; a potpourri area of formulas, calculating, and general options; and Lotus compatibility options for old Lotus 1-2-3 users (assuming that there are still some of you left) who are just now upgrading to Excel to make the transition easier.
Book I Chapter 2
Customizing Excel 2013
