Welcome toExcel2007.Tips.Net
Helpful Links
Car Tips
Cooking Tips
Wedding Tips
Word2007 Tips
Newest Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
Subscribe
Disabling the AutoFill Feature
Summary: AutoFill is a great editing tool that comes in particularly handy when you are first creating a worksheet. You may, at some point, want to turn off the feature. This tip shows how you can do this.The AutoFill feature of Excel is a great timesaver when you need to fill in a series of cells based on the content in other cells. It is also a feature that you can turn off, if you prefer. (For instance, the AutoFill handle visible at the bottom-right corner of a selection may be distracting to you, and you want to turn it off.)
To turn off AutoFill, follow these steps:
- Click the Office button, then click Excel Options. Excel displays the Excel Options dialog box.
- Click the Advanced option at the left of the dialog box. (Click here to see a related figure.)
- In the Editing Options area, clear the Enable Fill Handle and Cell Drag-and-Drop check box.
- Click on OK.
Besides turning off AutoFill, the above steps also turn off the ability to drag the contents of a cell from one location to another.
Create and Merge! Using Word's mail merge tool you can quickly and easily combine data from a variety of data sources to create great individualized documents that incorporate your data in ways that you control. WordTips: Mail Merge Magic is an invaluable source for learning how to harness the full power of Word's mail merging capabilities. Check out WordTips: Mail Merge Magic today!