Why not print (CTRL+P) this tip and
Microsoft Excel 'Quick Tip'
Editing Using Your Keyboard
Entering and editing formulas are the two most common tasks in
Excel. You are constantly clicking back and forth between the
cell and the formula bar. I'm a big believer of knowing both a
keyboard method and a mouse method for almost everything.
Here are some tricks that will allow you to edit a cell without
reaching for your mouse.
- Use the arrow keys to move to the cell.
- Press the F2 key to enter edit mode.
- While in edit mode, use these tips to make changes.
- Use the arrow keys if you need to select cells to use in
your formula. When selecting cells, remember to press F2 to
toggle between edit mode and select mode.
- Press the HOME key to move the cursor to the beginning of
- Press the END key to move the cursor to the end of the
- Hold down the CTRL key plus the left or right arrow to move
quickly through the formula.
- Hold down the SHIFT key and use the left or right key to
highlight a part of your formula.
- Press the END key and then CTRL+SHIFT+HOME to select the
- If you need to, you can copy (CTRL+C) and paste (CTRL+V)
parts of your formula.
- When you've finished making changes to your formula, press
ENTER to accept the changes or press the ESC key to cancel
changes (i.e. if you've made a mistake).
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 TheExcelAddict.com/Newsletter.htm and you could win a really cool prize.
You'll be amazed how much time you'll save just by learning a few of these tips.
Copyright © All Rights Reserved by
Close this window