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. how to improve grammar level all by yourselfMay 17, 2017 at 1:41 PM

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

    ReplyDelete
  2. http://resume-service.org/blog/page/8May 25, 2017 at 8:56 PM

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

    ReplyDelete
  3. John NapierJune 6, 2020 at 1:41 AM

    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. Jason492February 6, 2021 at 12:59 AM

    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

Image
" Ctrl + + " (add rows or columns) and " Ctrl + - " (delete rows or columns) are the easy shortcuts one may remember while adding and deleting rows/columns in Microsoft Excel. Adding rows or columns: If you wish to add rows above the current cell... just press "shift + spacebar" (discussed in my earlier post) to select the current row and then press "Ctrl + +". It will insert a row over the current row. Press "Ctrl + +" repeatedly to insert as many rows. Similarly, "ctrl + spacebar" and then "Ctrl + +" adds a column before the current column. You may try pressing "Ctrl + +" without selecting a row or a column. In such a case, you may get a pop-up (as shown in the image) where you can choose an option of adding a row or a column. Deleting rows or columns: "shift + spacebar" followed by "Ctrl + -" deletes the selected row & "ctrl + spacebar" followed by "Ct
Read more

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

Image
Most of the users are very used to formula like " COUNTIF "or " SUMIF "... Excel offers "S" factor adding spice to these handy formulas...  Sumif: usual syntax is =Sumif(criteria range, criteria, sum range) where you want to sum a given range of cells based on a condition in another range of cells. "Sumifs" acts one step further. The syntax is =Sumifs(Sum range, Criteria range1, criteria1, Criteria range2, criteria2...) and go on to add upto 9 criteria . This is handy when we need to sum a range based on more than one criteria. Similarly, we are quite used to "Countif" formula while counting a given range based on a filter criteria. Just like sumifs, countifs offers the same operation with multiple criteria filtration. Countif syntax: =Countif(Count range, Criteria). The countifs syntax gets changed to =countifs(Criteria range1, criteria1, criteria range2, criteria2....) . This too works upto 9 criteria . Excel really mak
Read more

Excel Keyboard Shortcuts - Handy during day to day work

I've had few posts earlier on few excel shortcuts. Navigation powered by "Ctrl" in Excel Shortcut to insert current date in a cell Shortcut to AutoFilter So, here I am, back with some more interesting shortcuts which will make your excel spreadsheet experience simpler. Let me start with some "CTRL" combinations which will be very handy for formating cells to match your requirements: CTRL + 1 : Opens the "Format Cells" dialog box CTRL + 2 : is to make the contents of the cell BOLD (this is a toggle key, to unbold use same CTRL + 2) CTRL + 3 : is to make the contents of the cell ITALICS (this is a toggle key) CTRL + 4 : is to underline the contents of the cell (this is a toggle key) CTRL + 5 : is to strike through the contents of the cell (this is a toggle key) CTRL + 9 : is to hide the entire row (to unhide use SHIFT + CTRL + 9) CTRL + 0 : is the hide the entire column (to unhide use SHIFT + CTRL + 0) CTRL + ~ : is to show or
Read more