Microsoft Excel Useful Short Keys
Do you use Microsoft Excel in daily Life? Then you have to use these short keys to save your time. |
Shortcut |
Description |
|
Tab |
Move to the next cell, Left
to right of the currently selected cell. |
|
Ctrl+A |
Select
all items of a worksheet. |
|
Ctrl+B |
Bold all cells of
the highlighted section. |
|
Ctrl+C |
Copy all cells of
the highlighted section. |
|
Ctrl+D |
Press This to Fills
the cell beneath with the contents of the selected cell. Then you have to
press Ctrl+D to fill them with the contents of the original
cell. You have to fill more than one cell and select the source cell and
press Ctrl+Shift+Down to select multiple cells. |
|
Ctrl+F |
Press this to Search
in current sheet. |
|
Ctrl+G |
Press this to Go to the
certain area. |
|
Ctrl+H |
Find and replace the
item. |
|
Ctrl+I |
Puts italics on
all cells of the highlighted section. |
|
Ctrl+K |
Insert
the hyperlink. |
|
Ctrl+L |
Press this Open the Create
Table dialog box. |
|
Ctrl+N |
Creates a new workbook. |
|
Ctrl+O |
Opens a workbook. |
|
Ctrl+P |
Print the current sheet. |
|
Ctrl+R |
You have to fill the cell
to the right with the contents of the selected cell. do you want to fill more
than one cell, then select the source cell and press Ctrl+Shift+Right to
select multiple cells. Then you have to press Ctrl+R to fill
them with the contents of the original cell. |
|
Ctrl+S |
Saves the open
worksheet. |
|
Ctrl+T |
Open the Create
Table dialog box. |
|
Ctrl+U |
Underlines all cells
of the highlighted section. |
|
Ctrl+V |
Pastes the copied thing
to the clipboard. |
|
Ctrl+W |
Closes the current
workbook. |
|
Ctrl+X |
Cuts all cells of
the highlighted section. |
|
Ctrl+Y |
Revise the last entry
(redo). |
|
Ctrl+Z |
Undo the last
action. |
|
Ctrl+1 |
Changes
the format of the selected cells. |
|
Ctrl+2 |
Bold all cells of the
highlighted section. |
|
Ctrl+3 |
Puts italics all cells of
the highlighted section. |
|
Ctrl+4 |
Underlines all cells of
highlighted section. |
|
Ctrl+5 |
Puts a strike
through all cells of the highlighted section. |
|
Ctrl+6 |
Show or hide object. |
|
Ctrl+7 |
Show or hide
the toolbar. |
|
Ctrl+8 |
Toggles the outline
symbol. |
|
Ctrl+9 |
Hide rows. |
|
Ctrl+0 |
Hide columns. |
|
Ctrl+Shift+: |
Enter the current time. |
|
Ctrl+; |
Enters the current date. |
|
Ctrl+` |
It Changes between
displaying cell values or formulas in the worksheet. |
|
Ctrl+' |
Copies the formula from
the cell above. |
|
Ctrl+Shift+" |
Copies the value from
cell above. |
|
Ctrl+- |
Delete the selected
column or row. |
|
Ctrl+Shift+= |
Insert a new column or
row. |
|
Ctrl+Shift+~ |
This Key Switches between
showing Excel formulas or their values in cells. |
|
Ctrl+Shift+@ |
Apply time formatting. |
|
Ctrl+Shift+! |
Apply comma formatting. |
|
Ctrl+Shift+$ |
Apply currency
formatting. |
|
Ctrl+Shift+# |
Apply date formatting. |
|
Ctrl+Shift+% |
Apply percentage
formatting. |
|
Ctrl+Shift+^ |
Apply exponential
formatting. |
|
Ctrl+Shift+* |
This key helps to Select
a current region around the active cell. |
|
Ctrl+Shift+& |
Places border around
selected cells. |
|
Ctrl+Shift+_ |
Removes the border. |
|
Ctrl++ |
Insert. |
|
Ctrl+- |
Delete. |
|
Ctrl+Shift+( |
Un hide rows. |
|
Ctrl+Shift+) |
Un hide columns. |
|
Ctrl+/ |
Selects the array
containing the active cell. |
|
Ctrl+\ |
Press this to Select the
cells that have a static value or don’t match the formula in the active cell. |
|
Ctrl+[ |
Press this to Select all
cells referenced by formulas in the highlighted section. |
|
Ctrl+] |
Press this to Select
cells that contain formulas that reference the active cell. |
|
Ctrl+Shift+{ |
Press this to Select all
cells directly or indirectly referenced by formulas in the highlighted
section. |
|
Ctrl+Shift+} |
Press this to Select
cells which contain formulas that directly or indirectly reference the active
cell. |
|
Ctrl+Shift+| (pipe) |
Press this to Select the
cells within a column that don’t match the formula or static value in the
active cell. |
|
Ctrl+Enter |
This key Fills the
selected cells with the current entry. |
|
Ctrl+Spacebar |
Select the entire column. |
|
Ctrl+Shift+ Spacebar |
Select the entire
worksheet. |
|
Ctrl+Home |
Move to the cell A1. |
|
Ctrl+End |
Move to the last cell
with text on the worksheet. |
|
Ctrl+Tab |
This key Move between Two
or more open Excel files. |
|
Ctrl+Shift+Tab |
Activates/ Opens the
previous workbook. |
|
Ctrl+Shift+A |
Inserts argument names
into a formula. |
|
Ctrl+Shift+F |
Opens the drop-down
menu for fonts. |
|
Ctrl+Shift+O |
Selects all the cells
that contain comments. |
|
Ctrl+Shift+P |
Open the drop-down menu
for point size. |
|
Shift+Insert |
Paste what is stored on
the clipboard. |
|
Shift+Page Up |
In a single column,
highlights all cells above that is selected. |
|
Shift+Page Down |
In a single column,
highlights all cells above that is selected. |
|
Shift+Home |
This key Highlight all
text to the left of the cursor. |
|
Shift+End |
This key Highlight all
text to the right of the cursor. |
|
Shift+Up Arrow |
Extend the highlighted
area up one cell. |
|
Shift+Down Arrow |
Extend the highlighted
area down one cell. |
|
Shift+Left Arrow |
Extend the highlighted
area left one character. |
|
Shift +Right Arrow |
Extend the highlighted
area right one character. |
|
Alt+Tab |
Cycle through
application. |
|
Alt+Spacebar |
Open the system menu. |
|
Alt+Backspace |
Undo. |
|
Alt+Enter |
While typing text in the
cell, pressing Alt+Enter to moves to the next line, to
allow for multiple lines of text in one cell. |
|
Alt+= |
You can create a formula
to sum all of the above cells. |
|
Alt+' |
Allow formatting on a
dialog box. |
|
F1 |
Open the help menu. |
|
F2 |
Edit the
selected cell. |
|
F3 |
After a name is
created, F3 will paste all the names. |
|
F4 |
Repeats last action. For
example, if you have changed the color of any text in another cell,
by pressing F4 changes the text in cell to the same color. |
|
F5 |
Goes to a specific cell.
For example, C8. |
|
F6 |
Move to the
next pane. |
|
F7 |
Spell check selected text
or document. |
|
F8 |
Enters Extend Mode. |
|
F9 |
Recalculates every
workbook. |
|
F10 |
Activate the menu
bar. |
|
F11 |
Create
a chart from selected data. |
|
F12 |
Save As option. |
|
Shift+F1 |
Open the "What's
This?" windows. |
|
Shift+F2 |
Allow the user to edit a
cell comment. |
|
Shift+F3 |
Open the
Excel formula window. |
|
Shift+F5 |
Bring up a search box. |
|
Shift+F6 |
Move to the previous
pane. |
|
Shift+F8 |
Add a selection. |
|
Shift+F9 |
Performs calculate
function on active sheet. |
|
Ctrl+F3 |
To Open Excel Name
Manager. |
|
Ctrl+F4 |
Close the current window. |
|
Ctrl+F5 |
Restores the window size. |
|
Ctrl+F6 |
Go to the Next workbook. |
|
Ctrl+Shift+F6 |
Previous workbook. |
|
Ctrl+F7 |
Move the window. |
|
Ctrl+F8 |
Resize the window. |
|
Ctrl+F9 |
Minimize the current
window. |
|
Ctrl+F10 |
Maximize the currently
selected window. |
|
Ctrl+F11 |
Inserts the macro sheet. |
|
Ctrl+F12 |
Opens a file. |
|
Ctrl+Shift+F3 |
You can create names by
using those of either row or column labels. |
|
Ctrl+Shift+F6 |
Moves to the previous
worksheet window. |
|
Ctrl+Shift+F12 |
Print the current
worksheet. |
|
Alt+F1 |
Insert a chart. |
|
Alt+F2 |
Save As option. |
|
Alt+F4 |
Exit Excel. |
|
Alt+F8 |
Open the macro dialog
box. |
|
Alt+F11 |
Open the Visual Basic
editor. |
|
Alt+Shift+F1 |
Create a new worksheet. |
|
Alt+Shift+F2 |
Save the current
worksheet. |