|
Sr No
|
Key
|
Description
|
|
1
|
CTRL+PgUp
|
Switches
between worksheet tabs, from left-to-right.
|
|
2
|
CTRL+PgDn
|
Switches
between worksheet tabs, from right-to-left.
|
|
3
|
CTRL+SHIFT+(
|
Unhides any hidden rows within the selection.
|
|
4
|
CTRL+SHIFT+)
|
Unhides any hidden columns within the selection.
|
|
5
|
CTRL+SHIFT+&
|
Applies
the outline border to the selected cells.
|
|
6
|
CTRL+SHIFT_
|
Removes
the outline border from the selected cells.
|
|
7
|
CTRL+SHIFT+~
|
Applies
the General number format.
|
|
8
|
CTRL+SHIFT+$
|
Applies
the Currency format with two decimal places (negative numbers in
parentheses).
|
|
9
|
CTRL+SHIFT+%
|
Applies
the Percentage format with no decimal places.
|
|
10
|
CTRL+SHIFT+^
|
Applies
the Exponential number format with two decimal places.
|
|
11
|
CTRL+SHIFT+#
|
Applies
the Date format with the day, month, and year.
|
|
12
|
CTRL+SHIFT+@
|
Applies
the Time format with the hour and minute, and AM or PM.
|
|
13
|
CTRL+SHIFT+!
|
Applies
the Number format with two decimal places, thousands separator, and minus
sign (-) for negative values.
|
|
14
|
CTRL+SHIFT+*
|
Selects
the current region around the active cell (the data area enclosed by blank
rows and blank columns). In a
PivotTable, it selects the entire PivotTable report.
|
|
15
|
CTRL+SHIFT+:
|
Enters
the current time.
|
|
16
|
CTRL+SHIFT+"
|
Copies
the value from the cell above the active cell into the cell or the Formula
Bar.
|
|
17
|
CTRL+SHIFT+Plus (+)
|
Displays
the Insert dialog box to insert blank cells.
|
|
18
|
CTRL+Minus (-)
|
Displays
the Delete dialog box to delete the selected cells.
|
|
19
|
CTRL+;
|
Enters the current date.
|
|
20
|
CTRL+`
|
Alternates
between displaying cell values and displaying formulas in the worksheet.
|
|
21
|
CTRL+'
|
Copies a
formula from the cell above the active cell into the cell or the Formula Bar.
|
|
22
|
CTRL+1
|
Displays
the Format Cells dialog box.
|
|
23
|
CTRL+2
|
Applies
or removes bold formatting.
|
|
24
|
CTRL+3
|
Applies
or removes italic formatting.
|
|
25
|
CTRL+4
|
Applies
or removes underlining.
|
|
26
|
CTRL+5
|
Applies
or removes strikethrough.
|
|
27
|
CTRL+6
|
Alternates
between hiding objects, displaying objects, and displaying placeholders for
objects.
|
|
28
|
CTRL+8
|
Displays
or hides the outline symbols.
|
|
29
|
CTRL+9
|
Hides
the selected rows.
|
|
30
|
CTRL+0
|
Hides
the selected columns.
|
|
31
|
CTRL+A
|
Selects
the entire worksheet. If the worksheet
contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the current region and its summary
rows. Pressing CTRL+A a third time selects the
entire worksheet. When the insertion point
is to the right of a function name in a formula, displays the Function
Arguments dialog box. CTRL+SHIFT+A inserts the argument names and parentheses when the
insertion point is to the right of a function name in a formula.
|
|
32
|
CTRL+B
|
Applies
or removes bold formatting.
|
|
33
|
CTRL+C
|
Copies
the selected cells. CTRL+C followed by
another CTRL+C displays the Clipboard.
|
|
34
|
CTRL+D
|
Uses the
Fill Down command to copy the contents and format of the topmost cell of a
selected range into the cells below.
|
|
35
|
CTRL+F
|
Displays
the Find and Replace dialog box, with the Find tab selected. SHIFT+F5 also displays
this tab, while SHIFT+F4 repeats the last Find action. CTRL+SHIFT+F opens
the Format Cells dialog box with the Font tab selected.
|
|
36
|
CTRL+G
|
Displays
the Go To dialog box. F5 also displays
this dialog box.
|
|
37
|
CTRL+H
|
Displays
the Find and Replace dialog box, with the Replace tab selected.
|
|
38
|
CTRL+I
|
Applies
or removes italic formatting.
|
|
39
|
CTRL+K
|
Displays
the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink
dialog box for selected existing hyperlinks.
|
|
40
|
CTRL+N
|
Creates
a new, blank workbook.
|
|
41
|
CTRL+O
|
Displays
the Open dialog box to open or find a file.
CTRL+SHIFT+O selects all cells that contain
comments.
|
|
42
|
CTRL+P
|
Displays
the Print dialog box. CTRL+SHIFT+P opens the Format Cells dialog box with the Font tab
selected.
|
|
43
|
CTRL+R
|
Uses the
Fill Right command to copy the contents and format of the leftmost cell of a
selected range into the cells to the right.
|
|
44
|
CTRL+S
|
Saves
the active file with its current file name, location, and file format.
|
|
45
|
CTRL+T
|
Displays
the Create Table dialog box.
|
|
46
|
CTRL+U
|
Applies
or removes underlining. CTRL+SHIFT+U
switches between expanding and collapsing of the formula bar.
|
|
47
|
CTRL+V
|
Inserts
the contents of the Clipboard at the insertion point and replaces any
selection. Available only after you have cut or copied an object, text, or
cell contents. CTRL+ALT+V displays the Paste Special dialog box. Available only
after you have cut or copied an object, text, or cell contents on a worksheet
or in another program.
|
|
48
|
CTRL+W
|
Closes
the selected workbook window.
|
|
49
|
CTRL+X
|
Cuts the
selected cells.
|
|
50
|
CTRL+Y
|
Repeats
the last command or action, if possible.
|
|
51
|
CTRL+Z
|
Uses the
Undo command to reverse the last command or to delete the last entry that you
typed. CTRL+SHIFT+Z uses
the Undo or Redo command to reverse or restore the last automatic correction
when AutoCorrect Smart Tags are displayed.
|
