10 Excel Shortcuts Meant to Save You Time
Disclaimer: These tips are known to work in Excel 2010. They may or may not work in other versions of Excel.
Excel can be an extremely powerful business tool, if you know how to use it correctly. Take the hassle out of locating commonly used features, and save some time, with these 10 useful Excel shortcuts.
CTRL + Page Down / CTRL
+ Page Up Move Between Worksheets
Both of these commands work the same, by moving you quickly through the workbook tabs at the bottom, but which command you use depends on which direction you want to go.
CTRL + Page Down will move through the tabs from left to right. This is helpful when you are on the first workbook tab, and want to move to others in the series.
CTRL + Page Up will move through the workbook tabs from right to left. So, once you’ve viewed your last workbook tab, you can easily move back to the first tab (or any other tab before the one you’re on) by pressing CTRL + Page Up.
CTRL + SHIFT + & Apply Borders
Pressing CTRL + SHIFT + & applies a thin black border to the selected area. Cells must be pre-selected before using this shortcut for this command to work.
CTRL + SHIFT + _ Un-apply Borders
Similarly, pressing CTRL + SHIFT + _ un-applies the border to the selected area. Again, cells containing the border you wish to remove must be pre-selected before using this shortcut.
CTRL + SHIFT + ~ General Number Formatting
With the applicable cells selected, press CTRL + SHIFT + ~ to format a cell with General Number formatting.
CTRL + SHIFT + $ Currency Formatting
Press CTRL + SHIFT + $ to apply currency formatting to the selected cells. Formatting will include two decimal places.
CTRL + SHIFT + % Percentage Formatting
To apply Percentage formatting, with no decimal places, highlight the applicable cells, then press CTRL + SHIFT + %.
CTRL + SHIFT + # Date Formatting
To apply date formatting (with month and year), highlight the selected cells, then press CTRL + SHIFT + #.
CTRL + SHIFT + @ Time Formatting
Similarly, to apply time formatting, including hours and minutes, AM and PM, select the appropriate cells, then press CTRL + SHIFT +@.
CTRL + ; Enters Current Date
To enter today’s date into a cell, select the cell, then press CTRL +; (semi-colon).
CTRL + SHIFT + : Enters Current Time
Similarly, to enter the current time into a cell, in AM / PM formatting, select the cell, then press CTRL + SHIFT + : (colon).