Search For Blogs, Submit Blogs, The Ultimate Blog Directory RSS Directory Blog Directory & Search engine Directory of Computers/Tech Blogs

Sitemap

Syndicate

Syndicate content

User login

Who's online

There are currently 0 users and 1 guest online.

Recent comments

Microsoft Excel Cheat Sheet

Execute Excel command using a keyboard Shortcut

Many of the commands in Excel can be accessed by your keyboard, instead of clicking with your mouse. This can increase your productivity, because when you don't use your mouse, your hands remain on the keyboard, so you can do your work much faster.

On this Microsoft Excel cheat sheet I explain many useful keyboard shortcuts and what's the result of each shortcut. Also I explain some frequently used formulas. With the help of these formulas you can make for example speadsheets that track your home finances, so you can easily see your earnings and where your money was spent.

I hope you'll enjoy this Microsoft Excel cheat sheet.

Keyboard
shortcut		 This
will result in
Ctrl+1 Shows
the 'Format Cells' dialog box.
Ctrl+2
or Ctrl+B		 Toggles
bold formatting.
Ctrl+3
or Ctrl+I		 Toggles
italic formatting.
Ctrl+4 or Ctrl+U Toggles
underline formatting.
Ctrl+5 Toggles
strikethrough formatting.
Ctrl+6 Toggles
hiding or displaying objects (like charts) and it's placeholders.
Ctrl+7 Toggles
displaying the standard toolbar.
Ctrl+8 Toggles
displaying outline symbols.
Ctrl+9 Hides
the current row.
Ctrl+0 Hides
the current column.
Ctrl+( Unhides
hidden rows in the current selection.
Ctrl+) Unhides
hidden columns in the current selection.
Ctrl+$ Currency
format with two decimal places.
Ctrl+& Add
outline borders to the current selection.
Ctrl+_ Removes
outline borders from the current selection.
Ctrl+# Date
format.
Ctrl+` Toggles
between showing values and formulas.
Ctrl++ Displays
the Insert dialog.
Ctrl+- Displays
the Delete dialog.
Ctrl+^ Exponential
format.
Ctrl+~ General
number format.
Ctrl+! Another
number format with thousands separator and two decimals.
Ctrl+% Percentage
format.
Ctrl+@ Time
format.
Ctrl+* Selects
cells around the current cell that belong to eachother.
Home Go
to column A of the row of the currently selected cel.
Ctrl+Home Go
to cell A1.
Ctrl+Shift+Home Select
all cells from the current cell to cell A1.
Ctrl+Shift+End Selects
all cells from the current cell to the last used cell on
the Excel document.
Ctrl+End Go
to the cell of the last row and column in which row and
column you entered some data.
Ctrl+. Whenever
you selected some rows and columns, this shortcut will navigate
you to the corners of your current selection.
Shift+left
arrow		 Selects
the current cell and the cell left from it.
Shift+right
arrow		 Selects
the current cell and the cell right from it.
Shift+up
arrow		 Selects
the current cell and the cell above it.
Shift+down
arrow		 Selects
the current cell and the cell below it.
Ctrl+' Copies
the data from the cell above. In case the cell above contains
a formula, the formula is copied instead of just the calculate
value of the formula.
Ctrl+; Puts
the current date in the cell.
Ctrl+: Puts
the current time in the cell.
Ctrl+" Copies
value from the cell above. In case the cell above contains
a formula, still only the value is copied, not the formula.
Delete Delete
the content of the current cell or selection.
Ctrl+A
or Ctrl+Shift+Spacebar		 Selects
all cells of the current worksheet.
Ctrl+C
or Ctrl+insert		 Copies
the current cell or selection. When Ctrl+C is pressed twice,
the clipboard will be displayed.
Ctrl+D Fill
down command. Fills all cells in a selection with the format
and contents of the topmost cells.
Alt+E
M		 Move
or copy active sheet.
Alt+E
L		 Delete
active sheet.
Ctrl+F
or Shift+F5		 Find.
Shift+F4 Repeat
last find action.
Ctrl+G
or F5		 Displays
the Go To dialog.
Ctrl+H Replace.
Ctrl+K Insert
or edit hyperlink.
Ctrl+L Creates
a list of the current selection.
Ctrl+N Create
a new Excel document.
Ctrl+O Open
an existing Excel document.
Alt+O
H R		 Rename
the active worksheet.
Ctrl+P Print
dialog.
Ctrl+R Fill
right command. Fills all cells in a selection with the format
and contents of the leftmost cells.
Ctrl+S Saves
the current Excel document.
Ctrl+V
or Shift+insert		 Pastes
the current cell or selection.
Ctrl+W Closes
current Excel document.
Ctrl+X Cuts
the current cell or selection.
Ctrl+Y Repeat
the last action.
Ctrl+Z Undo
the last action.
Tab Move
to the next cell.
Ctrl+Tab Go
to the next tab in a dialog box or go to the next open Excel
document.
Ctrl+Shift+Tab Go
to the previous tab in a dialog box or go to the previous
open Excel document.
Shift+Tab Move
to the previous cell or previous option in a dialog box.
Ctrl+Shift+Right
arrow		 Select
a continuous range of cells to the right.
Ctrl+Shift+Left
arrow		 Select
a continuous range of cells to the left.
Ctrl+Shift+Up
arrow		 Select
a continuous range of cells above the current cell.
Ctrl+Shift+Down
arrow		 Select
a continuous range of cells below the current cell.
Ctrl+Right
arrow		 Move
to the last cell to the right in a continuous range of cells
with values.
Ctrl+Left
arrow		 Move
to the first cell to the left in a countinuous range of
cells with values.
Ctrl+Up
arrow		 Move
to the first cell above in a continuous range of cells with
values.
Ctrl+Down
arrow		 Move
to the last cell below in a continuous range of cells with
values.
Ctrl+Spacebar Selects
entire column of the selected cell.
Shift+Spacebar Selects
entire row of the selected cell.
Left
arrow		 Move
one cell to the left.
Right
arrow		 Move
one cell to the right.
Up
arrow		 Move
one cell above.
Down
arrow		 Move
one cell down.
Ctrl+arrow
key		 Move
to the last cell in a continous range of cells with data
or move to the next cell which contains data.
Ctrl+Page
up		 Go
to the previous worksheet (in case you are not on the first
worksheet).
Ctrl+Page
down		 Go
to the next worksheet (in case you are not on the last worksheet).
Ctrl+Shift+Page
up		 Selects
the current worksheet and the previous worksheet.
Ctrl+Shift+Page
down		 Selects
the current worksheet and the next worksheet.
Alt+Page
up		 Move
to the cell on the previous page on the same worksheet.
Alt+Page
down		 Move
to the cell on the next page on the same worksheet.
Shift+Enter Complete
editing the current cell and go to the cell above.
F1 Display
the help window.
Ctrl+F1 Toggles
display of current task window.
Alt+F1
or F11		 Make
a chart of the currently selected cells. Notice that a new
worksheet will be made on which the chart is displayed.
Alt+Shift+F1 Insert
a new worksheet.
F2 Edits
cell or formula and positions the cursor at the end.
Shift+F2 Enter
a comment for the current cel.
F6 Moves
to the next splitted part of the worksheet when it is splitted.
Shift+F6 Moves
to the previous splitted part of the worksheet when it is
splitted.
Ctrl+F6 Go
to the next Excel document when more than one Excel document
is open.
F7 Displays
spelling dialog.
Ctrl+F7 Move
the Excel document (when not maximized). Move with the arrow
keys. When finished moving press Enter. To cancel moving,
press Escape.
F8 Extend
mode. When you press this key, in the statusbar of your
document EXT will be displayed. In this mode you can select
cells with the arrow keys. Press F8 again to exit this mode.
Ctrl+F8 Size
the Excel document (when not maximized). Resize with the
arrow keys. When finished resizing press Enter. To cancel
resizing, press Escape.
Shift+F8 Allows
to add a selection of cells to another selection of cells,
resulting in multiple selected regions.
Alt+F8 Displays
the macro execution dialog.
F9 Calculate
all formulas in all worksheets of all open Excel documents.
Shift+F9 Calculate
all formulas on the active worksheet of the active Excel
document.
Ctrl+F9 Minimize
the active Excel document.
F10 Selects
the menu bar.
Ctrl+F10 Maximize
the selected Excel document.
Shift+F10 Displays
the context or shortcut menu.
Shift+F11 Insert
a new worksheet.
Alt+F11 Displays
the VBA macro editor.
Alt+Shift+F11 Displays
the script editor.
F12 Displays
the Save As dialog.

Formula This
will result in
=SUM() Sum
of the values in the specified cells.
=MIN() The
minimal value of the specified cells.
=MAX() The
maximal value of the specified cells.
=ABS() Returns
the absolute value (or in other words: makes a negative
number positive).
=AVERAGE() The
average of the specified cells.
=COUNT() The
number of cells that contain numeric information in the
specified cells.
=COUNTA() The
number of cells that contain any information in the specified
cells.