Home » Featured, General, Tips and Tricks

Useful Excel shortcuts – episode 2

Submitted by on Sunday, 28 February 20108 Comments
Useful Excel shortcuts – episode 2

This post is in continuation to my previous post on Excel Keyboard Shortcut. This time I have chosen shortcuts for ‘Formatting’ commands.

  • Activate the Formatting dialog box: The shortcut key for this command is CTRL+1. This command will activate the Formatting dialog box which can then be used for applying any kind of formatting to the selected cells.
  • Apply ‘General’ format: The general format is the default formatting applied on the cells. Whenever you open a new workbook, the cells have general formatting. The shortcut key to apply ‘General’ format to selection is – CTRL+SHIFT+~. A general format also means removing other formatting, such as Number, Text, Date formatting. It does not mean to removing borders, etc.
  • Apply ‘Number’ format: CTRL+SHIFT+1 applies the number format to the selection of cells. The formatting includes – number format, the thousand separator and 2 decimal points formatting
  • Apply ‘Time’ format: To apply a time formatting to selected cells, CTRL+SHIFT+2 is used. This will apply ‘HH:MM AM/PM’ formatting to the selected cells
  • Apply ‘Date’ format: The date formatting converts the cell formatting to DD-MMM-YY format. The shortcut key for this formatting is CTRL+SHIFT+3
  • ‘Currency’ format: The key combination – CTRL+SHIFT+4 applies the currency format to the selected cells. It applies the ‘$’ sign to numbers and also applies 2 decimal point formatting
  • Percentage formatting: To apply ‘%’ sign and the formatting, use the key combination – CTRL+SHIFT+5
  • Applying borders: To apply outline border to cells use the CTRL+SHIFT+&. This will apply normal outline border to the selection range

For the border formatting, please note that the given key combination would not apply border to all cells in the range. It will only apply outline to the whole range as such. Please see the image below:

Related Posts Plugin for WordPress, Blogger...
Signature

8 Comments »

  • Arvind said:

    Thank you.

    I was looking for a website which can teach me Excel in a simplest way.

    And i just found one.

    Keep writing more.

    Regards
    Arvind Chugh

    # 12 April 2010 at 6:56 am
  • admin said:

    Hi Arvind,

    Thanks for your note. I will surely continue to write in as mush simple language as I can. Hope you like the posts.

    Excel Matic

    # 13 April 2010 at 12:10 am
  • Kumaresan said:

    Hi Peoples,

    Good and great job Keep it up!

    Have a Nice Day!

    Regards,
    Kumaresan.P,
    Salem.

    # 27 June 2010 at 3:26 pm
  • Mohit Khurana (author) said:

    Hi Kumaresan,

    Thanks a lot for encouraging words.

    Cheerz!
    Mohit

    # 27 June 2010 at 7:18 pm
  • Krishna said:

    Hey Arvind!

    Good One Bro –

    I was always struggling to change the formats of Number from general to Number with decimals – this one was really helpful

    I would appreciate if you could post some shortcuts on alignment !

    Krishna

    # 5 July 2010 at 12:44 pm
  • Krishna said:

    Sory

    I was addressing The Author….Mohit !

    Krishna

    # 5 July 2010 at 12:46 pm
  • dev said:

    this has helped me alot

    # 22 October 2010 at 1:58 am
  • Mohit Khurana (author) said:

    @KRishna and @Dev: Thanks a lot guys. You will see more posts coming on this blog soon. I have not been able to keep much of activity on this blog since some time.

    Thanks a gain guys. Your appreciation only keeps me going on.

    - Mohit

    # 27 October 2010 at 6:54 pm

Leave your response!

Add your comment below, or trackback from your own site. You can also subscribe to these comments via RSS.

Be nice. Keep it clean. Stay on topic. No spam.

You can use these tags:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

This is a Gravatar-enabled weblog. To get your own globally-recognized-avatar, please register at Gravatar.