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



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.