The Enable AutoComplete for Cell Values check box controls whether, when you re in Microsoft Office

Draw QR Code JIS X 0510 in Microsoft Office The Enable AutoComplete for Cell Values check box controls whether, when you re

entering text in a cell, AutoComplete suggests a matching item from another cell in the column once you ve typed enough letters to identify it For example, if you enter Madrid in cell A1, enter Malaga in cell A2, and type mad in cell A3, AutoComplete suggests Madrid to complete that cell AutoComplete can greatly speed up entering repetitive information in columns But if you find AutoComplete distracting, clear this check box

formats and formulas to new rows you add to the end of a list This check box is selected by default and, in most cases, this feature saves time and effort If not, clear this check box

percentage entries by 100 before displaying them Most people find this option helpful it enables you to enter percentages without thinking about them When this option is turned off, entering 1 in a Percentage-formatted cell displays 100%, entering 2 displays 200%, and so on

The Show Paste Options Buttons check box controls whether, when you paste data,

Excel displays the Paste Options Smart Tag, which is useful for changing the format or content of data you ve pasted

Options Smart Tag when you insert cells (for example, by using an Insert | Cells command) This Smart Tag lets you change the way in which inserting the cells has affected the existing rows and columns in the worksheet

The General tab of the Options dialog box (Figure 2-7) contains a wide variety of useful settings everything from the number of files in the recently used file list to the folder that Excel opens by default Here are details of the settings:

FIGURE 2-7

The General tab of the Options dialog box includes settings for adjusting the recently used file list and the folder that Excel opens by default

everybody uses A1 reference style, which is the default, but you may occasionally need to use R1C1 reference style

hover the mouse over interface items such as the toolbar buttons This check box is selected by default

recently used files at the bottom of the File menu and in the Getting Started task pane The Entries text box controls the number of entries The default setting is 4; you can set any number from 1 to 9

Properties dialog box when you first save a file This check box is cleared by default By entering properties rigorously in every workbook, you can make it easier to identify the contents of workbooks by searching

applications give you audio feedback when you take actions such as scrolling, using toolbars, or displaying dialog boxes (Turning on sound feedback in one application turns it on for all of the Office applications) To receive sound feedback, you must download the Office Sounds add-in from the Microsoft Office Download Center and install it

workbook contains The default is 3 If you frequently have to add or delete worksheets, adjust the number accordingly The limits are 0 and 255 sheets

and Save As use initially If you want Excel to display a different location, type it or paste it into this text box

templates, workbooks, or add-ins that you want Excel to open automatically when you start Excel Some people find this option useful, but many don t

The three options on the Save tab of the Options dialog box (Figure 2-8) are crucial for keeping valuable data as safe as possible

FIGURE 2-8

The Save tab of the Options dialog box contains only three options, but each of them is crucial to keeping your work safe from mishaps

These are the available options:

automatically saves data while you re working so as to be able to recover from a disaster such as Excel crashing or your computer losing power This check box is selected by default, and it s best to leave it selected Set the value in the text box to a value that suits you The default setting is 10 minutes, but you may want to set a shorter interval if your computer has been unstable You may want to turn off AutoRecover if you prefer to save your documents manually every time you make an important change, or if you find that AutoRecover s automatic saves interfere with your work or your concentration (The status bar displays Saving AutoRecover Info and a progress readout during each AutoRecover save)