"Excel Shortcut Keys: Top 10 Excel Keyboard Shortcuts To Help You Format Excel Data As You Wish"

Do you know that the Excel shortcut keys can apply to most cell formatting?

As you know, Excel provides a wide range of formatting for both the contents of cells and their appearance so that the cells show exactly the data you want, and in the right format.

You can achieve that by using the mouse or keyboard shortcuts. The following are the 14 shortcuts keys to format cells, hiding and unhiding rows and columns.

1. Display the Style dialog box

2. Display the Format Cells dialog box
[Ctrl]+[1] This shortcut works only with the 1 key in the key row, not the 1 key on the keypad.

3. Apply the General format

4. Apply the two-decimal-place Currency format

5. Apply the Percentage format (no decimal places)

6. Apply the Exponential format with two decimal places

7. Apply the DD+MMM+YY date format

8. Apply the HH:MM AM/PM time format

9. Apply the two-decimal-place number format with the thousands separator

10. Toggle strikethrough

Shortcuts for Hiding and Unhiding Rows and Columns

11. Hide all selected rows

12. Hide all selected columns

13. Unhide hidden rows in the selection

14. Unhide hidden columns in the selection

For more Excel shortcut keys related to other Excel functionality, please 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

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.