Excel Level-Up: Day 5

Number Formats

Today, we are going to share with you some easy to remember but not everyone knows short cut keys. 

The following short cuts are very helpful in formatting your worksheet.

[Control] + [Shift] + [`] to format cell as “General”

[Control] + [Shift] + [1] to format cell as “Number”

[Control] + [Shift] + [2] to format cell as “Time”

[Control] + [Shift] + [3] to format cell as “Date”

[Control] + [Shift] + [4] to format cell as “Currency”

[Control] + [Shift] + [5] to format cell as “Percentage”

[Control] + [Shift] + [6] to format cell as “Scientific”

This should be fairly easy to memorize if you refer to the symbol represented by each number.

Never change the number format of the cells by using the drop down menu again!

Go back to previous awesome trick: Excel Level-Up: Day 4

Proceed to next awesome trick: Excel Level-Up: Day 6