← Back to Applications List

Ctrl+W

Close a workbook

Closes the current workbook.

💡 Hint: Window (close window)

Ctrl+O

Open a workbook

Opens an existing workbook.

💡 Hint: Open

Ctrl+S

Save a workbook

Saves the current workbook.

💡 Hint: Save

Ctrl+C

Copy selection

Copies the selected cells or text to the clipboard.

💡 Hint: Copy

Ctrl+V

Paste selection

Pastes content from the clipboard.

💡 Hint: V = paste motion

Ctrl+Z

Undo recent action

Undoes the last action.

💡 Hint: Zlast letter (undo last action)

Delete

Remove cell contents

Removes the contents of selected cells (preserves formatting).

💡 Hint: Delete = delete

Ctrl+X

Cut selection

Cuts the selected cells and moves them to the clipboard.

💡 Hint: Xscissors shape (cut)

Ctrl+B

Apply bold formatting

Applies or removes bold formatting from selected text.

💡 Hint: Bold

Alt+H

Go to the Home tab

Navigates to the Home tab on the ribbon.

💡 Hint: Home

Alt+N

Go to the Insert tab

Navigates to the Insert tab on the ribbon.

💡 Hint: NiNsert

Alt+P

Go to the Page Layout tab

Navigates to the Page Layout tab on the ribbon.

💡 Hint: Page layout

Alt+A

Go to the Data tab

Navigates to the Data tab on the ribbon.

💡 Hint: AdAta

Alt+W

Go to the View tab

Navigates to the View tab on the ribbon.

💡 Hint: WvieW

Ctrl+9

Hide the selected rows

Hides the selected rows.

💡 Hint: 9 = hide rows

Ctrl+0

Hide the selected columns

Hides the selected columns.

💡 Hint: 0 = hide columns

Move one cell up

Moves one cell up in a worksheet.

💡 Hint: ↑ = move up

Down

Move one cell down

Moves one cell down in a worksheet.

💡 Hint: ↓ = move down

Left

Move one cell left

Moves one cell left in a worksheet.

💡 Hint: ← = move left

Right

Move one cell right

Moves one cell right in a worksheet.

💡 Hint: → = move right

Ctrl+Arrow

Move to edge of data region

Moves to the edge of the current data region.

💡 Hint: Ctrl+Arrow = jump to edge of data

Ctrl+End

Move to last cell on worksheet

Moves to the last used cell on the worksheet.

💡 Hint: End = last

Ctrl+Home

Move to beginning of worksheet

Moves to the beginning of the worksheet (cell A1).

💡 Hint: Home = beginning

Page Down

Move one screen down

Moves one screen down in the current view.

💡 Hint: Page Down = page down

Page Up

Move one screen up

Moves one screen up in the current view.

💡 Hint: Page Up = page up

Ctrl+Page Down

Move to next sheet

Moves to the next sheet in the workbook.

💡 Hint: Page Down = next sheet

Ctrl+Page Up

Move to previous sheet

Moves to the previous sheet in the workbook.

💡 Hint: Page Up = previous sheet

Ctrl+1

Open Format Cells dialog

Opens the Format Cells dialog box.

💡 Hint: 1 = number one formatting

Edit active cell

Puts the active cell into edit mode.

💡 Hint: F2 = edit

Ctrl+Shift+:

Enter current time

Enters the current time into the cell.

💡 Hint: : = time separator

Ctrl+;

Enter current date

Enters the current date into the cell.

💡 Hint: ; = date entry

Ctrl+I

Apply italic formatting

Applies or removes italic formatting from selected text.

💡 Hint: Italic

Ctrl+U

Apply underline formatting

Applies or removes underline formatting from selected text.

💡 Hint: Underline

Ctrl+A

Select entire worksheet

Selects the entire worksheet.

💡 Hint: All

Ctrl+Space

Select entire column

Selects the entire column of the current cell.

💡 Hint: Space = vertical space (column)

Shift+Space

Select entire row

Selects the entire row of the current cell.

💡 Hint: Shift+Space = horizontal space (row)

Shift+Arrow

Extend selection

Extends the selection by one cell.

💡 Hint: Shift+Arrow = extend selection

Calculate all worksheets

Calculates all worksheets in all open workbooks.

💡 Hint: F9 = calculate

Alt+=

Insert AutoSum formula

Inserts the AutoSum formula.

💡 Hint: = = formula start

Shift+F3

Insert a function

Opens the Insert Function dialog.

💡 Hint: F3 = Function

Ctrl+Shift++

Insert cells

Opens the Insert dialog to insert blank cells.

💡 Hint: + = add (insert)

Ctrl+-

Delete cells

Opens the Delete dialog to delete selected cells.

💡 Hint: - = delete

Ctrl+K

Insert hyperlink

Opens the Insert Hyperlink dialog.

💡 Hint: KlinK

Check spelling

Runs spell check on the document.

💡 Hint: F7 = spell check

Ctrl+T

Create table

Displays the Create Table dialog.

💡 Hint: Table

F12

Save As

Displays the Save As dialog.

💡 Hint: F12 = Save As

Alt+Enter

Start new line in cell

Starts a new line in the same cell.

💡 Hint: Alt+Enter = line break in cell

Microsoft Excel