Page 74 - Excel 2013 All-in-One For Dummies

56 Exercising Your Options
Figure 2-6:
The Editing and Cut, Copy, and Paste options
on the Advanced tab control how Excel behaves during editing.
Working the worksheet editing options
As you can see in Figure 2-6, the options in the Editing Options and Cut, Copy, and Paste sections on the Advanced tab control what happens when you edit the contents of an Excel worksheet.
When you first open the Advanced tab of the Excel Options dialog box, all of the check box options in the Editing Options and Cut, Copy, and Paste sec- tions are checked with the exception of these three:
✦ Automatically Insert a Decimal Point to have Excel add a decimal point during data entry of all values in each worksheet using the number of places in the Places text box. (See Book II, Chapter 1 for details.)
✦ Zoom on Roll with IntelliMouse to have Excel increase or decrease the screen magnification percentage by 15 percent on each roll forward and back of the center wheel of a mouse that supports Microsoft’s IntelliMouse technology. When this option is not checked, Excel scrolls the worksheet up and down on each roll forward and back of the center wheel.
✦ DoNotAutomaticallyHyperlinkScreenshottopreventExcelfrom automatically creating hyperlinks to any screenshots that you take of the Windows desktop using the Screenshot option on the Illustrations but- ton’s drop-down list on the Insert tab. (See Book V, Chapter 2 for details.)