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.
|