Sponsored

MS Excel: Advanced Keyborard shortcut keys

Key
Description
CTRL+SHIFT+(
To Unhide the rows
CTRL+SHIFT+&
To draw border outline for selected cells
CTRL+SHIFT_
To remove border outline for selected cell
CTRL+SHIFT+~
To apply number format
CTRL+SHIFT+$
To apply currency format for selected cell
CTRL+SHIFT+%
To apply percentage format
CTRL+SHIFT+^
To apply scientific number format
CTRL+SHIFT+#
To apply date format with day, month, year display
CTRL+SHIFT+@
To apply time format for selected cell that displays hour, minutes, AM/PM
CTRL+SHIFT+!
To apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
CTRL+SHIFT+*
To select  the current region around the active cell (the data area enclosed by blank rows and blank columns).
In a Pivot Table, it selects the entire Pivot Table report.
CTRL+SHIFT+:
To automatically enter the current time.
CTRL+SHIFT+"
To copy the value from the cell above the active cell into the cell or the Formula Bar.
CTRL+SHIFT+Plus (+)
To Display the Insert dialog box to insert blank cells.
CTRL+Minus (-)
To Displays the Delete dialog box to delete the selected cells.
CTRL+;
To enter the current date.
CTRL+`
Alternates between displaying cell values and displaying formulas in the worksheet.
CTRL+'
Copies a formula from the cell above the active cell into the cell or the Formula Bar.


CTRL+1
Displays the Format Cells dialog box.
CTRL+2
Applies or removes bold formatting.
CTRL+3
Applies or removes italic formatting.
CTRL+4
Applies or removes underlining.
CTRL+5
Applies or removes strikethrough.
CTRL+6
Alternates between hiding and displaying objects.
CTRL+8
Displays or hides the outline symbols.
CTRL+9
Hides the selected rows.
CTRL+0
Hides the selected columns.