Excel: Some cell formatting shortcuts

Here are some keyboard shortcuts for some commonly used tasks. You may find it difficult to remember initially but gradually you would love to remember them.


Format as currency with 2 decimal places
CTRL + SHIFT +$
Format as percent with no decimal places
CTRL + SHIFT +%
Apply number format
CTRL + SHIFT + !
Apply date format
CTRL + SHIFT + #
Apply time format
CTRL + SHIFT + @
Apply general format
CTRL + SHIFT + ~
Apply exponential number format
CTRL + SHIFT + ^
Apply outline border to selection
CTRL + SHIFT + ;
Remove outline border to selection
CTRL + SHIFT + _


Note: These shortcut will execute system default formating eg: if the default currency of the system is "$" the currency formated cell will bear "$". If you wish to apply any other formating other than the system default, use "Ctrl + 1" to open to cell formating dialogue box.


Tip: "CTRL + SHIFT + _" also works in Acrobat Reader 7 & later version to rotate the page anticlockwise..!!


The best option to use these shortcuts is to place a print of these shortcuts in your workstation so that you may refer to them until you get used to it.

Comments

  1. These tips on formatting the cells will help to facilitate the work with the computer for each person.

    ReplyDelete
  2. Oh! that is the thing for me to have it hand and use from time to time.

    ReplyDelete
  3. If you need Fresh Food which is Good to Eat then you should have to search near by hotels for the fresh and healthy food.

    ReplyDelete
  4. Sensitive skin? Pregnant? Just want to be one with nature? You have to use All Natural Face Wash.Because it is “Ideal for those who are struggling to find the right skincare products that are free from chemicals, preservatives, and fragrances, natural face wash can be a great alternative.

    ReplyDelete

Post a Comment

Popular posts from this blog

Keyboard Shortcut to add/delete rows or columns in Excel

"CountIF" or "SumIF" with an extra "S" makes the difference...

Alternative for SUMIF and SUMIFS