"Excel 2003 Keyboard Shortcuts: 11 Must-know Shortcut Keys When Working with Formulas"


Why you must learn the Excel 2003 keyboard shortcuts?

When you construct worksheets for a project, you'll probably spend a fair amount of time working with formulas and functions. You'll be glad to know that Excel provides plenty of keyboard shortcuts for working with formulas. Don't believe, see it for yourself!

1. Start creating a formula
[=]

2. Enter the formula in the cell
[Enter]

3. Enter the formula as an array formula
[Ctrl]+[Shift]+[Enter]

4. Toggle between displaying formula results and formulas
[Ctrl]+`

5. Display the Insert Function dialog box
[Shift]+[F3]

6. Display the Function Arguments dialog box
[Ctrl]+[A]

7. Enter the argument names in the Formula bar
[Ctrl]+[Shift]+[A]

8. Displays the Paste Name dialog box
[F3]

9. Insert an AutoSum formula in the active cell
[Alt]+[=]

10. Copy the value of the cell above the active cell
[Ctrl]+[Shift]+["]

11. Copy the formula from the cell above the active cell
[Ctrl]+[']

These 10 keyboard shortcuts work mainly on the Excel formulas and functions, if you want to discover more shortcut keys on other Excel topics, feel free to visit the following links:



Can't find what you're looking for? Try Google Search!

Custom Search


Related Links:

Add To Your Social Bookmarks: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Books:

Click on the image to view the details of the book.
Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007




XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.