Page 46 - Excel Timesaving Techniques for Dummies

07_574272 ch06.qxd 10/1/04 10:22 PM Page 31
Technique 6 Utilizing Excel’s
Editing Settings

Technique

xcel’s Edit settings, found on the Edit tab of the Options dialog box
Save Time By (shown in Figure 6-1), offer a wide array of editing options, most of
Ewhich are selected by default and seldom, if ever, need changing.
Selecting new cell
pointer directions Therefore, instead of focusing solely on how to change these options to
suit your work habits, this technique also covers how to more efficiently
Dumping AutoComplete use of a few them when modifying your spreadsheets.
Using cell drag-and-drop
This technique begins by covering how and when to change the direction
Direct editing in cells in which the cell pointer moves when you press Enter and then gives you
the lowdown on why you might want to disable the AutoComplete fea-
ture. You then discover how to efficiently use Excel’s drag-and-drop edit-
ing (and when it’s best to stick with the old cut-and-paste standby). The
technique concludes by giving you pointers on when to edit a cell’s con-
tents directly in the cell and when to rely on the old tried-and-true cell
editing on the Excel Formula bar.

• Figure 6-1: The Edit settings offer a wide array of editing options that seldom
need changing.