70 Excel Shortcut Commands
If you want to be expert in Excel using Keyboard you must use the following command:
SNO.
|
Shortcut
|
Description
|
1
|
F2
|
Edit the selected cell.
|
2.
|
Ctrl + F3
|
After a name has been created, F3 will
paste names.
|
3.
|
F4
|
Repeat last action. For example, if you
changed the color of text in another cell, pressing F4 will change the text
in cell to the same color.
|
4.
|
F5
|
Go to a specific cell. For example, C6.
|
5.
|
F7
|
Spell check selected text or document.
|
6.
|
F11
|
Create chart from selected data.
|
7.
|
Ctrl+Shift+;
|
Enter the current time.
|
8.
|
Ctrl+;
|
Enter the current date.
|
9.
|
Alt+Shift+F1
|
Insert New Worksheet.
|
10.
|
Alt+Enter
|
While typing text in a cell, pressing
Alt+Enter will move to the next line, allowing for multiple lines of text in
one cell.
|
11.
|
Shift+F3
|
Open the Excel formula window.
|
12.
|
Shift+F5
|
Bring up search box.
|
13.
|
Ctrl+1
|
Open the Format Cells window.
|
14.
|
Ctrl+A
|
Select all contents of the worksheet.
|
15.
|
Ctrl+B/ Ctrl +2
|
Bold highlighted selection.
|
16.
|
Ctrl+I / Ctrl +3
|
Italic highlighted selection.
|
17.
|
Ctrl+K
|
Insert link.
|
18.
|
CTRL+PgUp
|
Switches between worksheet tabs, from
left-to-right.
|
19.
|
CTRL+PgDn
|
Switches between worksheet tabs, from
right-to-left.
|
20.
|
CTRL+SHIFT+9
|
Unhides any hidden rows within the
selection.
|
21.
|
CTRL+SHIFT+7
|
Applies the outline border to the
selected cells.
|
22.
|
CTRL+SHIFT+-
|
Removes the outline border from the selected
cells.
|
23.
|
CTRL+SHIFT+~
|
Applies the General number format.
|
24.
|
CTRL+SHIFT+4
|
Applies the Currency format with two
decimal places (negative numbers in parentheses).
|
25.
|
CTRL+SHIFT+5
|
Applies the Percentage format with no
decimal places.
|
26.
|
CTRL+SHIFT+6
|
Applies the Scientific number format with
two decimal places.
|
27.
|
CTRL+SHIFT+3
|
Applies the Date format with the day,
month, and year.
|
28.
|
CTRL+SHIFT+2
|
Applies the Time format with the hour and
minute, and AM or PM.
|
29.
|
CTRL+SHIFT+1
|
Applies the Number format with two
decimal places, thousands separator, and minus sign (-) for negative values.
|
30.
|
CTRL+SHIFT+8
|
Selects the current region around the
active cell (the data area enclosed by blank rows and blank columns).
|
31.
|
CTRL+SHIFT+’
|
Copies the value from the cell above the
active cell into the cell or the Formula Bar.
|
32.
|
CTRL+SHIFT+Plus (+)
|
Displays the Insert dialog box to insert
blank cells.
|
33.
|
CTRL+Minus (-)
|
Displays the Delete dialog box to delete
the selected cells.
|
34.
|
CTRL+`
|
Alternates between displaying cell values
and displaying formulas in the worksheet.
|
35.
|
CTRL+'
|
Copies a formula from the cell above the
active cell into the cell or the Formula Bar.
|
36.
|
Ctrl+U / Ctrl +4
|
Applies or removes underlining.
|
37.
|
CTRL+5
|
Applies or removes strikethrough.
|
38.
|
CTRL+6
|
Alternates between hiding and displaying
objects.
|
39.
|
CTRL+8
|
Displays or hides the outline symbols.
|
40.
|
CTRL+9
|
Hides the selected rows.
|
41.
|
CTRL+0
|
Hides the selected columns.
|
42.
|
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.
|
43.
|
CTRL+F
|
Displays the Find and Replace dialog box,
with the Find tab selected.
|
44.
|
CTRL+L
|
Displays the Create Table dialog box.
|
45.
|
CTRL+N
|
Creates a new, blank workbook.
|
46.
|
CTRL+O
|
Displays the Open dialog box to open or
find a file.
|
47.
|
CTRL+P
|
Displays the Print tab in Microsoft
Office Backstage view.
|
48.
|
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.
|
49.
|
CTRL+S
|
Saves the active file with its current
file name, location, and file format.
|
50.
|
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.
|
51.
|
CTRL+W
|
Closes the selected workbook window.
|
52.
|
CTRL+X
|
Cuts the selected cells.
|
53.
|
CTRL+Y
|
Repeats the last command or action, if
possible.
|
54.
|
CTRL+Z
|
Uses the Undo command to reverse the last
command or to delete the last entry that you typed.
|
55.
|
Ctrl+Space
|
Select entire column.
|
56.
|
Shift+Space
|
Select entire row.
|
57.
|
Ctrl+F6
|
Switch between open workbooks or windows.
|
58.
|
Ctrl+Home
|
Move to cell A1.
|
59.
|
Ctrl+End
|
Move to last cell in active sheet.
|
60.
|
Ctrl+Tab
|
Move between Two or more open Excel
files.
|
61.
|
Alt+=
|
Create a formula to sum all of the above
cells.
|
62.
|
Ctrl+Arrow key
|
Move to next section of text.
|
63.
|
Ctrl+~
|
Switch between showing Excel formulas or
their values in cells.
|
64.
|
Ctrl+F7
|
Move window
|
65.
|
Ctrl+F8
|
Resize window
|
66.
|
Ctrl+F9
|
Minimize workbook
|
67.
|
Ctrl+F10
|
Maximize or restore window
|
68.
|
Alt+F11
|
Visual Basic Editor
|
69.
|
Alt+’
|
Format Style dialog box
|
70.
|
Alt+F4
|
Exit
|
Comments
Post a Comment