Microsoft Excel shortcut keys

F2

Edit the selected cell.

F3

After a name has been created, F3 will paste names.

F4

Repeat last action. For example, if you changed the color of text in another cell, pressing F4 will change the text in cell to the same color.

F5

Go to a specific cell. For example, C6.

F7

Spell check selected text or document.

F11

Create chart from selected data.

Ctrl + Shift + ;

Enter the current time.

Ctrl + ;

Enter the current date.

Alt + Shift + F1

Insert New Worksheet.

Alt + Enter

While typing text in a cell, pressing Alt + Enter will move to the next line, allowing for multiple lines of text in one cell.

Shift + F3

Open the Excel formula window.

Shift + F5

Bring up search box.

Ctrl + 1

Open the Format Cells window.

Ctrl + A

Select all contents of the worksheet.

Ctrl + B

Bold highlighted selection.

Ctrl + I

Italic highlighted selection.

Ctrl + K

Insert link.

Ctrl + S

Save the open worksheet.

Ctrl + U

Underline highlighted selection.

Ctrl + 1

Change the format of selected cells.

Ctrl + 5

Strikethrough highlighted selection.

Ctrl + P

Bring up the print dialog box to begin the printing process.

Ctrl + Z

Undo last action.

Ctrl + F3

Open Excel Name Manager.

Ctrl + F9

Minimize current window.

Ctrl + F10

Maximize currently selected window.

Ctrl + F6

Switch between open workbooks or windows.

Ctrl + Page up

Move between work sheets in the same document.

Ctrl + Page down

Move between work sheets in the same document.

Ctrl + Tab

Move between Two or more open Excel files.

Alt + =

Create a formula to sum all of the above cells.

Ctrl + '

Insert the value of the above cell into the cell currently selected.

Ctrl + Shift + 1

Format number in comma format.

Ctrl + Shift + 4

Format number in currency format.

Ctrl + Shift + 3

Format number in date format.

Ctrl + Shift + 5

Format number in percentage format.

Ctrl + Shift + 6

Format number in scientific format.

Ctrl + Shift + 2

Format number in time format.

Ctrl + Arrow key

Move to next section of text.

Ctrl + Space

Select entire column.

Shift + Space

Select entire row.

Ctrl + -

Delete the selected column or row.

Ctrl + Shift + =

Insert a new column or row.

Ctrl + Home

Move to cell A1.

Ctrl + ~

Switch between showing Excel formulas or their values in cells.

CTRL+O

To open workbook

CTRL+SHIFT+TAB

To activate the previous workbook

CTRL+N

To create a new workbook

CTRL+SHIFT

Removes the outline border from the selected cells.

CTRL+SHIFT+*

Selects the current region around the active cell (the data area enclosed by blank rows and blank columns). In a PivotTable, it selects the entire PivotTable report.

CTRL+SHIFT+

Enters the current time.

CTRL+A

Select All

CTRL+C

Copy

CTRL+X

Cut

CTRL+V

Paste

CTRL+F

Find

CTRL+H

Replace

CTRL+B

Bold

CTRL+I

Italics

CTRL+U

Underline

CTRL+F5

Restore window size

CTRL+F6

Next workbook window

CTRL+F9

Minimize workbook

CTRL+F11

Open VBE

CTRL+SHIFT+

Copies the value from the cell above into the active cell or the formula bar.

CTRL+6

Alternates between hiding objects, displaying objects, and displaying placeholders.

CTRL+8

Displays or hides the outline symbols

CTRL+9

Hides the selected rows.

CTRL+0

Hides the selected columns.

F4

During formula typing, adjusts the reference type (absolute to relative); otherwise, repeats the last action.

CTRL+

Inserts the current date.

CTRL+Z

Uses the Undo command to reverse the last command or delete the last entry.

CTRL+SHIFT+&

Applies the outline border to the selected cells.

CTRL+SHIFT+~

Applies the General number format.

CTRL+SHIFT+$

Applies the Currency format with two decimal places (negative numbers in parentheses).

CTRL+SHIFT+%

Applies the percentage format with no decimal places.

CTRL+/

Copies value from the cell above to the current cell.

CTRL+SHIFT+F2

Edits a cell comment.

ALT+F8

Opens the macro dialog box.

ALT+=

Auto-sums selected cells and places the value in the cell below.

CTRL+SHIFT+$

Applies currency format to the current cell.

CTRL+SHIFT+!

Applies comma format to the current cell.

ALT+F

Activates the font dropdown list

ALT+P

Activates the font point size dropdown list.

CTRL+P

Displays the Print dialog box.

CTRL+R

Uses the Fill Right command to copy the contents and format of the leftmost cell into the cells to the right.

CTRL+S

Saves the active file with its current file name, location, and format

CTRL+T

Displays the Create Table dialog box.

CTRL+W

Closes the selected workbook window.

CTRL+Y

Repeats the last command or action, if possible.