"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:

• 16 Powerful Shortcut Keys to Help You Easily Navigate in Worksheets
• How to Use the Shortcut Keys for Entering and Editing Data in Excel?
• The 19 Amazing Shortcut Keys for Selecting Cells, Rows, and Columns in Excel
• Top 10 Excel 2003 Keyboard Shortcuts To Help You Format Excel Data As You Wish
• 10 Great Microsoft Excel Keyboard Shortcuts for Applying Outline and Cell Borders
• Excel 2003 Shortcut Keys for Working in Print Preview

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

Custom Search

Related Links:

• Microsoft Word Keyboard Shortcuts - Function Keys
• Microsoft PowerPoint Keyboard Shortcuts - Function Keys
• Microsoft Outlook Keyboard Shortcuts - Function Keys

Add To Your Social Bookmarks: Blink Del.icio.us Digg
Furl Google Simpy Spurl Technorati Y! MyWeb