Exceltechie.com

Easiest way to learn excel on the planet
Facebook-exceltechie Twitter-exceltechie Linkedin-exceltechie
|| Novice || Beginner || Intermediate || Advanced || Specialist || Expert ||
Shortcut Key     Action Description
[Ctrl]+[Shift]+(Unhide row
[Ctrl]+[Shift]+)Unhide column
[Ctrl]+[Shift]+_Removes the outline border from the selected cells
[Ctrl]+[Shift]+!Applies the Number format [2 decimal places, thousands separator, and minus sign
[Ctrl]+[Shift]+"Copies the value from the cell above the active cell into the cell or the Formula Bar.
[Ctrl]+[Shift]+$Applies the Currency format with two decimal places (negative numbers in parentheses).
[Ctrl]+[Shift]+%Applies the Percentage format with no decimal places.
[Ctrl]+[Shift]+&Applies the outline border to the selected cells.
[Ctrl]+[Shift]+*Selects the current region around active cell (data area enclosed by blank rows and columns).
[Ctrl]+[Shift]+:Current time
[Ctrl]+[Shift]+@>Applies the Time format with the hour and minute, and AM or PM.
[Ctrl]+[Shift]+^Applies the Exponential number format with two decimal places
[Ctrl]+[Shift]+^Applies the Date format with the day, month, and year.
[Ctrl]+[Shift]+~Applies the General number format.
[Ctrl]+[Shift]+=Insert cell/row/column
[Ctrl]+[Shift]+Arrow KeyExtends selection of cells to the last nonblank cell in the same column/row
[Ctrl]+[Shift]+EndSelect from active cell to last cell in used range
[Ctrl]+[Shift]+HomeSelect from active cell to A1
[Ctrl]+[Shift]+L Filter
[Ctrl]+[Shift]+Oselects all cells that contain comments
[Ctrl]+[Shift]+POpens the Format Cells dialog box with Font tab selected
[Ctrl]+[Shift]+[Page Down]Selects the current and next sheet in a workbook
[Ctrl]+[Shift]+[Page Up]Selects the current and previous sheet in a workbook
[Ctrl]+[Shift]+[Tab]switches to the previous tab in a dialog box.
[Ctrl]+[Shift]+UExpanding and collapsing of the formula bar