Excel All Shortcuts Keys
1. Ctrl + S :-
Save a workbook
2. Ctrl + 0 :-
Hide the selected columns
3. Ctrl + 1 :-
Open the Format Cells dialog box
4. Ctrl + 5 :-
Apply or remove strike through
5. Ctrl + Shift
+ $ :- Apply currency format
6. Ctrl + Shift
+ % :- Apply percent format
7. Ctrl + Tab
:- Switch between open workbooks
8. Ctrl + P :- Print / Print Preview
9. Ctrl + Shift
+ # :- Apply Date format
10.
Ctrl + Shift + @
:- Apply Time format
11.
Ctrl + Shift + !
:- Apply Number format
12.
Ctrl + Shift + ~ :- Apply General format
13.
Ctrl + ' :-
Copy Above Content to Fill below
14.
Ctrl + X :- Cut
contents of a cell, selected data, or selected cell range
15.
Ctrl + C or
Ctrl + Insert :- Copy contents of a cell, selected data, or selected cell range
16.
Ctrl + V or
Shift + Insert :- Paste contents of a cell, selected data, or selected cell
range
17.
Ctrl + Alt + V
:- Open the Paste Special dialog box
18.
Ctrl + D =
Fill Down
19.
Ctrl + R -
Fill Right
20.
Ctrl + + -
Insert Column / Row
21.
Ctrl + - =
Delete Row / Column
22.
Ctrl + Space :-
Select the entire column
23.
Ctrl + Shift + Space
:- Select the entire worksheet
24.
Ctrl + Shift + &
:- Apply outline border
25.
Ctrl + Shift + _
(Underscore) :- Remove outline border
26.
Ctrl + 9 :-
Hide the selected rows
27.
Ctrl + F9 -
Minimize / Alt + Tab - Maximize / Switch
28.
Ctrl + F11 -
Insert Macro Name Sheet
29.
Ctrl + F12 =
Open Dialog box
30.
Ctrl + Shift
+ F1 - Hide Tab and Ribbon
31.
Ctrl + ; -
Insert Date
32.
CTRL + ~ =
Show and Hide All formulas from sheet
33.
Ctrl + Shift
+ ; - Insert Time
34.
Ctrl + H –
Replace
35.
Ctrl + K –
Hyperlink
36.
Ctrl + Shift
+ 9 :-
Unhide Rows
37.
Ctrl + F1 :-
Show or hide the ribbon
38.
Ctrl + Home :-
Move to the beginning of a worksheet
39.
Ctrl + End :-
Go to the most bottom right used cell
40.
Ctrl + Shift + U
:- Expand or collapse the formula bar
41.
Ctrl + F9 :- Minimize the workbook window
42.
Ctrl + Z :-
Undo an action
43.
Ctrl + Y :-
Redo an action
44.
Ctrl + N :-
Create a new workbook
45.
Ctrl + O :-
Open an existing workbook
46.
Ctrl + F10 =
Restore Window or Alt + Space +
R
47.
Ctrl + F3 =
Name Manager
48.
Ctrl + Shift
+ F3 - Create Names from Selection
49.
Ctrl + Left/Right
Arrow :- Move to the farthest cell left or right in the row
50.
Ctrl + Page
Up/Down :- Move to the previous or next worksheet
51.
Ctrl + W / CTRL
+ F4 :- Close a workbook (Alt + Space
+ C)
52.
Ctrl + Up/Down
Arrow :- Move to the top or bottom cell in the column
53.
Ctrl + F :-
Search in a spreadsheet, or use Find and Replace
---------------------------------------------------------------------------------------------------
1. Alt + H + W -
Wrap Text
2. Alt + A + T -
Apply and Remove Filter
3. ALT + N + V -
PIVOT TABLE
4. ALT + = :- Auto Sum
5. ALT + H + M + C - MERGE AND CENTER
6. Alt + A + Q -
Advance Filter
7. Alt + H + O + I -
Auto-fit Column Width
8. Alt + H + E + F -
Clear Format
9. Alt + I + R -
Insert Row
10.
Alt + I + C - Insert Colum
11.
Alt + H + B :- Add a border
12.
Alt + F :- Open the File tab menu
13.
Alt + H :- Go to the Home tab
14.
Alt + F8 :- Create, run, edit, or delete a macro
15.
Alt + F11 :- Open the Microsoft Visual Basic For
Applications Editor
16.
Alt + V + Z :-
Zoom in / Zoom Out
17.
Alt or F10 :- Turn key tips on or off
18.
Alt + F1 :- Create an embedded bar chart based on
select data (same sheet)
19.
Alt + Enter :- Insert a hard return within a cell
(while editing a cell)
20.
Alt + H + H :- Select a fill color
21.
Alt + Page Up/Down :- Move one screen to the right or
left in a worksheet
22.
Alt + Space +
X - Maximize or Ctrl + F10 -
Restore
23.
Alt + V + U - Full Screen
-----------------------------------------------------------------------------------------------------
1. F1 :- Open the Help pane
2. F2 :- Edit a cell
3. F3 :- Paste a cell name (if cells are named in
the worksheet)
4. F5 or CTRL + G :- Go to any cell by pressing F5 and typing
the cell coordinate or cell name.
5. F7 :- Check spelling
6. F8 :- Extend
Selection
7. F9 :- Calculate all worksheets in all open
workbooks
8. F11 :- Create a bar chart based on selected
data (on a separate sheet)
9. F12 :- Open the Save As dialog box
10.
Shift + F3 :-
Insert a function
11.
Tab = Go to the
Next cell & Shift + Tab :- Go to the previous cell
12.
Shift + F2 :-
Add or edit a cell comment
13.
Esc :- Cancel
an entry in a cell or the formula bar
14.
Enter :- Complete the Formula / Paste Content if
already copied
15.
EXCEL Ctrl + E -
Flash Fill
16.
Shift + Left/Right
Arrow :- Extend the cell selection to the left or right
17.
Shift + Space
:- Select the entire row
18.
Home :- Go to
the leftmost cell in the current row
19.
Page Up/Down :-
Move one screen up or down in a worksheet
20.
Shift + F11 :-
Insert a new worksheet
Excel all shorcut key
Usefull shortcut key
Gnb classes
shortcut keys For CPCT, CCC, NTPC, SSC, Bank Job etc