Friday, March 15, 2019

Excel Keyboard Shortcuts - Handy during day to day work


I've had few posts earlier on few excel shortcuts.

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 hide formula (this is a toggle key)
  • CTRL + - : brings up the delete cells dialog box
  • CTRL + + : brings up the insert cells dialog box
Another set of shortcuts is with the combination of SHIFT and CTRL:

  • SHIFT + CTRL + 1 : converts the number in the cell to decimal format with 2 decimal places
  • SHIFT + CTRL + 2 : converts the number in the cell to time format (your default system format)
  • SHIFT + CTRL + 3 : converts the number in the cell to date format (your default system format)
  • SHIFT + CTRL + 4 : converts the number in the cell to currency format (your default system format)
  • SHIFT + CTRL + 5 : converts the number in the cell to percentage format
  • SHIFT + CTRL + 6 : converts the number in the cell to scientific format (your default system format)
  • SHIFT + CTRL + 7 : adds outline border to the selected cell(s)
  • SHIFT + CTRL + - : Removes the border from the select cell(s)
Get used to these common shortcuts till I manage to compile few more.

You can find more such posts on the internet. So make sure you refer and make best use of the shortcuts.



2 comments:

  1. Regardless of your topic or subject, the dissertation must fulfill all academic requirements specified to your university. best dissertation writing service uk The specifications may also include the writing style, citations, formatting, templates used and usage of pictures and graphs.

    ReplyDelete
  2. This was a really great contest and hopefully I can attend the next one. It was alot of fun and I really enjoyed myself.. grammar tool

    ReplyDelete