"Excel Keyboard Shortcuts: How to Use the Shortcut Keys for Entering and Editing Data in Excel?"

Learn the Excel keyboard shortcuts now! Why? It really helps you in the process of entering and editing worksheet data.

The following are the Excel keyboard shortcuts for entering data in your worksheets and editing the existing entries in cells. Carefully read it, practices and use it!

1. Enter the entry in the cell and select the next cell
[Enter]

2. Cancel editing in the active cell
[Esc]

3. Enter the entry in the cell and select the next cell in the opposite direction
[Shift]+[Enter]

4. Enter the entry in the cell and select the next cell to the right
[Tab]

5. Enter the entry in the cell and select the next cell to the left
[Shift]+[Tab]

6. Fill the selected range with the entry
[Ctrl]+[Enter]

7. Enter the time in the active cell
[Ctrl]+[Shift]+[:]

8. Enter the date in the active cell
[Ctrl]+[;]

9. Display the Define Name dialog box
[Ctrl]+[F3]

10. Display the Create Names dialog box
[Ctrl]+[Shift]+[F3]

11. Display the AutoComplete drop+down list
[Alt]+[?]

12. Switch the active cell into Edit mode
[F2]

13. Insert a new comment or edit the existing comment
[Shift]+[F2]

14. Delete the contents of the active cell
[Backspace]

15. Delete from the insertion point to the end of the cell's contents
[Ctrl]+[Delete]

16. Begin a new line within the active cell
[Alt]+[Enter]

17. Undo the most recent AutoCorrect
[Ctrl]+[Shift]+[Z]

18. Cycle object display, placeholder display, and hiding
[Ctrl]+[6]

19. Delete the selected cells
[Ctrl]+[-]

20. Insert cells
[Ctrl]+[Shift]+[-]

Don't you feel like suddenly you're an Excel magician? I believe that you definitely can increase your productivity because you're more Excel-proficient now. To get more Excel shortcut keys, visit the links below:

• 16 Powerful Shortcut Keys to Help You Easily Navigate in Worksheets
• The 19 Amazing Shortcut Keys for Selecting Cells, Rows, and Columns in Excel
• 11 Must-know Shortcut Keys When Working with Formulas
• Top 10 Excel 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