"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

Fast Editing Using Your Keyboard

As I've said many times, Excel power users always learn more than one method to accomplish their everyday tasks in Excel. Sometimes you are in 'keyboard mode' where a keyboard shortcut would be easier. Other times you are in 'mouse mode' where clicking with your mouse is the quickest and best option.

Editing the contents of a cell is a common task in Excel where most users unnecessarily switch from 'keyboard mode' to 'mouse mode' because they don't know the keyboard shortcut. When you want to edit the active cell, simply press F2.

Once you are in edit mode, you can use your arrow keys to move around the formula bar. Pressing the HOME key brings you to the beginning of the formula. Pressing the END key brings you to the end. Holding down the SHIFT key while pressing an arrow key selects text. Holding down the CTRL key while pressing the arrow keys moves the cursor one full word at a time. You can also use a combination of CTRL+SHIFT+arrow key.

These shortcuts also work with many other programs. Just try them and see what you've been missing.

Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.