Microsoft Excel Shortcuts
>>>MS EXCEL SHORTCUTS<<<
|
Keys |
Function |
|
Ctrl + N |
Create a new workbook |
|
Ctrl + O |
Open an existing workbook |
|
Ctrl + S |
Save a workbook |
|
Ctrl + W |
Close a workbook |
|
Ctrl + Z |
Undo an action |
|
Ctrl + Y |
Redo an action |
|
Ctrl + Shift+ U |
Expand or collapse the formula bar |
|
Ctrl + F |
Search in a spreadsheet, or use
find & replace |
|
Ctrl + tab |
Switch between open workbooks |
|
Ctrl + F1 |
Show or hide the ribbon |
|
Ctrl + F2 |
Switch to print preview |
|
Shift + F3 |
Insert a function |
|
Ctrl + F4 |
Close excel |
|
Shift + F9 |
Calculate active worksheets |
|
Ctrl + F9 |
Minimize the workbook window |
|
Shift + F11 |
Insert a new worksheet |
|
Left/Right Arrow |
Move one cell to the left or right |
|
Ctrl + Left/Right Arrow |
Move to the farthest cell left or
right in the row |
|
Up/Down Arrow |
Move one cell up or down |
|
Ctrl + Up/Down Arrow |
Move to the top or bottom cell in
the column |
|
Tab |
Go to the next cell |
|
Shift + Tab |
Go to the previous cell |
|
Ctrl+ End |
Go to the most bottom right used
cell |
|
Home |
Go to the leftmost cell in the
current row |
|
Ctrl + Home |
Move to the beginning of a
worksheet |
|
Alt + Page up/Down |
Move one screen to the right or
left in a worksheet |
|
Ctrl + Page up/Down |
Move to the previous or next
worksheet |
|
Shift + Left/Right Arrow |
Extend the cell selection to the
left or right |
|
Shift + Space |
Select the entire row |
|
Ctrl + Space |
Select the entire column |
|
Ctrl + Shift + Space |
Select the entire worksheet |
|
Shift + F2 |
Add or edit a cell comment |
|
Ctrl + X |
Cut contents of a cell, selected
data, or selected cell range |
|
Ctrl + C (or) Ctrl + Insert |
Copy contents of a cell, Selected
data, or Selected cell range |
|
Ctrl + V (or) Ctrl + Insert |
Paste contents of a cell, Selected
data, or Selected cell range |
|
Delete |
Remove the contents of a cell,
Selected data, or Selected cell range |
|
Alt + H + D + C |
Delete the column |
|
Esc |
Cancel an entry in a cell or the formula bar |
|
Enter |
Complete an entry in a cell or the
formula bar |
|
Ctrl + B |
Add or remove bold to the contents
of a cell, selected data, or selected cell range |
|
Ctrl + I |
Add or remove italics to the contents
of a cell, selected data, or selected cell range |
|
Ctrl + U |
Add or remove underline to the
contents of a cell, selected data, or selected cell range |
|
Ctrl + Shift + & |
Apply Outline Border |
|
Ctrl + Shift + _(Underline) |
Remove outline border |
|
Ctrl + 9 |
Hide the selected rows |
|
Ctrl + 0 |
Hide the selected columns |
|
Ctrl + 1 |
Open the format cells dialog box |
|
Ctrl + 5 |
Apply or remove strikethrough |
|
Ctrl + Shift + $ |
Apply Currency format |
|
Ctrl + Shift + % |
Apply Percent format |
|
F1 |
Open the help pane |
|
F11 |
Create a bar chart based on
selected data(on separate sheet) |
|
F4 |
Repeat the last command |
|
F7 |
Check spelling |
|
F9 |
Calculate all worksheets in all
open workbooks |
|
F12 |
Open the save as dialog box |
|
F5 |
Go to any cell by pressing F5 |
|
F2 |
Edit a cell |
|
F3 |
Paste a cell name (if cells are
named in the worksheet) |
|
Alt or F10 |
Turn key tips on or off |
|
Alt + Q |
Go to the "Tell me what you
want to do" box |
|
Alt + F |
Open the file tab menu |
|
Alt + H |
Go to the home tab |
|
Alt + N |
Open the insert tab |
|
Alt + P |
Go to the page layout tab |
|
Alt + M |
Go to the formulas tab |
|
Alt + A |
Go to the data tab |
|
Alt + R |
Go to the review tab |
|
Alt + W |
Go to the view tab |
|
Alt + X |
Go to the add-ins tab |
|
Alt + Y |
Go to the help tab |
|
Alt + F8 |
Create, run, edit, or delete a
macro |
|
Alt + F1 |
Create an embedded bar chart based
on selected(on same sheet) |
|
Alt + F11 |
Open the Microsoft visual basic for
application editor |
|
Alt + Enter |
Insert a hard return within a cell
(While editing a cell) |
|
Alt + H + H |
Select a fill color |
|
Alt + H + B |
Add a border |
Post a Comment