.: Advanced Excel Microsoft - Expert Shortcuts, Tips and Tricks

Keyboard shortcuts for Microsoft Excel

Formatting

Keystroke Function

[Ctrl]B Bold the selection

[Ctrl]I Italicize the selection

[Ctrl]U Underline the selection

[Ctrl]5 Strike through the selection

[Alt] and ' Open the Style dialog box

[Ctrl]1 Open the Format Cells dialog box

[Ctrl][Shift]~ Apply General format

[Ctrl][Shift]$ Apply Currency format

[Ctrl][Shift]% Apply percentage format

[Ctrl][Shift]# Apply Date format

[Ctrl][Shift]@ Apply Time format

[Ctrl][Shift]! Apply Number format

[Ctrl][Shift]^ Apply Exponential number format

[Ctrl][Shift]& Apply an outline border to selection

[Ctrl][Shift] and _ Remove outline border from selection

Navigation

Move to the next worksheet in a workbook [Ctrl][Page Down]

Move to the previous worksheet in a workbook [Ctrl][Page Up]

Cycle between open workbooks [Ctrl][F6]
Move one cell up, down, left, or right Arrow keys

Move to the edge of the data region [Ctrl] and an arrow key

Move to the beginning of a row [Home]

Move to the beginning of a worksheet [Ctrl][Home]

Move to the end of the used portion of a worksheet [Ctrl][End]

Move between panes in a split worksheet [F6]

Display the active cell [Ctrl][Backspace]

Move down a cell in a selected range [Enter]

Move up a cell in a selected range [Shift][Enter]

Move one cell to the left in a selected range [Shift][Tab]

Move from corner cell to corner cell in a selected range [Ctrl] and . (period)

Selection techniques

Select a row [Shift][Spacebar]

Select a column [Ctrl][Spacebar]

Select an entire worksheet [Ctrl]A

Select from current cell(s) to the beginning of the row [Shift][Home]

Select from current cell(s) to last used cell in row [Shift][End][Enter]

Select from current cell(s) to the beginning of the worksheet [Ctrl][Shift][Home]
Select from current cell(s) to the end of the used portion of a worksheet [Ctrl][Shift][End]

Select the data region surrounding the active cell [Ctrl] and *

Select all cells that contain a comment [Ctrl][Shift]O

Select cells that a selected formula directly references [Ctrl] and [

Select formulas that directly reference the active cell [Ctrl] and ]

Workbook basics

Open a workbook [Ctrl]O

Create a new workbook [Ctrl]N

Save a workbook [Ctrl]S

Open the Save As dialog box [F12]

Print a workbook [Ctrl]P

Close a workbook [Ctrl]W

Insert a new worksheet [Shift][F11]

Hide selected rows [Ctrl]9

Display hidden rows in selection [Ctrl][Shift]9

Hide selected columns [Ctrl]0

Display hidden columns in selection [Ctrl][Shift]0

Open the Find tab of the Find And Replace dialog box [Ctrl]F

Open the Replace tab of the Find And Replace dialog box [Ctrl]H

Run a spelling check on a worksheet or selected text [F7]
Working with data

Complete an entry and move to the next cell [Enter]

Insert a new line within a cell [Alt][Enter]

Enable editing within a cell [F2]

Fill selected cells with an entry you type [Ctrl][Enter]

Fill data down through selected cells [Ctrl]D

Fill data through selected cells to the right [Ctrl]R

Create a name [Ctrl][F3]

Insert a hyperlink [Ctrl]K

Insert the current date [Ctrl] and ; (semicolon)

Insert the current time [Ctrl] and : (colon)

Cut the selected text or objects to the Clipboard [Ctrl]X

Copy the selected text or objects to the Clipboard [Ctrl]C

Paste the contents of the Clipboard [Ctrl]V

Repeat last action [Ctrl]Y

Undo last edit [Ctrl]Z

Delete from the insertion point to the end of the line Ctrl][Delete]

Add blank cells [Ctrl][Shift]+

Delete selected cells [Ctrl]- (hyphen)

Create a chart from a range of data [F11]

Formula shortcuts

Begin a formula =

Enter a formula as an array [Ctrl][Shift][Enter]

Display the Insert Function dialog box (Paste Function in Excel 97) [Shift][F3]

Paste a defined name into a formula [F3]

Insert a SUM AutoSum formula [Alt]=

Display the Function Arguments dialog box Type a function in the Formula bar and press [Ctrl]A

Copy the value from the cell above the current cell into the current cell [Ctrl][Shift] and "

Copy a formula from the cell above the current cell into the current cell [Ctrl] and '

Toggle between display of formulas and cell values [Ctrl] and `

Calculate values for sheets in all open workbooks [F9]

Calculate values for the current worksheet [Shift][F9]

Cancel an entry you're making in a cell or in the formula bar [Esc]