MS Excel 2016 Shortcuts Explanation 6th Part

This is the 6th part of shortcuts explanation series used in Microsoft Excel 2016. I will be explaining shortcuts for different formats in this post. I hope this will help you become more efficient user in Excel. Like before I have tested all of these shortcuts in latest version of MS Excel 2016.

Note; If you are following my posts you don’t need to re-read the following points.

Points to consider:

  • Some of these shortcuts might not work in all versions of Microsoft Excel.
  • Device without function keys (F1-F12) on its keyboard i.e. Chromebook, certain shortcuts will not work for you.
  • The plus sign means you have to press both mentioned keys together.

Ctrl+Shift+~

  • Use this Shortcut to make cell format general.
  • If the selected cell already had a different format this will make in general again from date, time, currency etc.

Ctrl+Shift+!

  • Use this Shortcut to change the selected cell format to number with two decimal places.
  • For Example, 2 will become 2.00

Ctrl+Shift+@

  • Use this Shortcut to change the selected cell format to Time.
  • By default, the time format with this shortcut is “h:mm AM/PM”
  • If the selected cell has a positive number, this shortcut will change it to “12:00 AM” and the number will be considered as number of days passed.
  • For example if the cell has a number 4 the formula bar will show “1/4/1900 12:00:00 AM” and if the number is 60 then “2/29/1900 12:00:00 AM”
  • If the selected cell has a negative number, you will get “#######

Ctrl+Shift+#

  • Use this Shortcut to change the selected cell format to date.
  • By default, the date format with this shortcut is “d-mmm-yy”.
  • Like the time format if the selected cell has a positive number then this shortcut will show the date as the number of days passed.
  • For example, if a cell has number 10 then the date it will convert into is “1/10/1900” and if 60 then “2/29/1900
  • If the selected cell has a negative number, you will get “#######” as soon you change it to positive the format will display date as per above rules.

Ctrl+Shift+$

  • Use this Shortcut to change the selected cell format to show currency sign.
  • By Default, the currency format will show with two decimal places and a dollar sign.
  • If the selected cell has a negative number, the amount will be shown in red font color and with brackets around it but still with two decimal places.

Ctrl+Shift+%

  • Use this Shortcut to change the selected cell format to show percentage.
  • Use this shortcut if you want to change the result from fraction to percentile format.
  • If you use it on a cell for example with number 20 in it this shortcut will change it to “2000%“.
  • By default, the result of division between two cells is shown in fraction use this shortcut key to change the result to percentage.

Ctrl+Shift+^

  • Use this Shortcut to change the selected cell format to scientific format.
  • For example, if selected cell has 2000 this shortcut will change it to “2.00E+04
  • Also note that you can use this other way round too. Just write 2.00E+04 and it will display “20000

General points

  • You can also use the generic shortcuts by pressing Alt Then H Then N press the down arrow to display format option or choose by pressing the 3 formats shown in the ribbon.
  • The most useful shortcut here is Ctr+1 to display the format cell display box with all format options in excel.

Previous Part

Next Part

Save

Save

Share This Post

Related Articles

© 2017 PC Shelf. All rights reserved. Site Admin · Entries RSS · Comments RSS
Powered by WordPress · Designed by Theme Junkie