Saturday, October 10, 2009

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.

4 comments:

  1. You always can publish something absorbing that does not waste minutes of your life like what you see on countless other sites essay tigers review . This is very interesting and I will be back for more. Thanks for sharing

    ReplyDelete
  2. The one thing advertisers concede to is there isn't sufficient time in the day to fulfill everything. Regularly the most ideal approach to discover additional time is to spare time.

    Enhancing your Excel abilities is an awesome place to start to paw back a couple of minutes on each venture, in light of the fact that Excel is an instrument utilized by the majority of us all the time. It has such a large number of extraordinary capacities that are not quickly obvious. Simply discovering one trap can spare you minutes consistently.

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

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

    ReplyDelete