Turning off AutoFill
Summary: AutoFill is a great feature in Excel when you want to fill in a series of cells based on the contents in other cells. It is also a feature that you can turn off. Some Excel users find the AutoFill handle, which is visible in the bottom-right corner of a selection, to be distracting and would like it turned off. Here is how to do this:
- Click on the File Menu or the Office Button in Excel 2007.
- Click on the Excel Options dialog box.
- Click on the Advanced option at the left of the dialog box.
- In the Editing Options area, clear the Enable Fill Handle and Cell Drag-and-Drop check box.
- Click on OK.
Note that this not only turns off AutoFill, the above steps also turn off the ability to drag the contents of a cell from one location to another.
|
Backing Up Your AutoCorrect Entries
Summary: AutoCorrect is a very useful feature in Excel that allows for the rapid correction of commonly misspelled words. It can be customized and I have a large list of words that I misspell in my AutoCorrect. I like to backup my AutoCorrect entries, so I can easily move the file to a new computer. Here is how to do this:
Excel's AutoCorrect information is stored in files with the ACL extension. If you want to make a copy of your AutoCorrect information, use the search capabilities in Windows to locate files with this extension and copy them to your backup destination.
| |
Back to top
Summary: There are times when it is useful to see all the formulas in a worksheet. Here is how to do this:
- Press the F5 function key.
- Excel displays the Go To dialog box.
- Click on Special.
- Excel displays the Go To Special dialog box.
- Choose the Formulas radio button.
- Using the four check boxes under the Formulas radio button, indicate the type of results that should be produced by the formulas you want selected.
- Click on OK.
Excel will now highlight all of the cells in the worksheet that contain formulas.
|
Summary: By default, Microsoft Word does not make backup copies of your files. Instead the old file is deleted after the new file is written to your hard drive. If you want Word to keep backup files here is how to do this:
- In Word 2010 and 2013 click on the File menu. In Word 2007 click on the Office Button.
- Click on the Word Options dialog box.
- Click on Advanced.
- Scroll down until you see the Save options. (Don't confuse this with clicking Save at the left side of the dialog box; they are not the same.)
- Click on Always Create Backup Copy, so there is a check mark in the check box.
- Click on OK.
When that is done Word will save a backup copy with the file extension .wbk in the same folder as the original document.
|