Excel shortcuts

Shortcut Keys in Excel PDF: The Ultimate Guide

If you work with Excel on a daily basis, you know that there are certain tasks that you perform over and over again. Whether it's creating a new workbook, inserting a new row, or copying and pasting data, there are certain actions that you perform on a regular basis. While you can always use the mouse to click on the various menu options to perform these tasks, it's often quicker and easier to use shortcut keys.

In this guide, we'll show you some of the most useful shortcut keys that you can use in Excel. We'll also provide a downloadable PDF that you can use as a reference.

Creating a New Workbook

To create a new workbook, you can use the shortcut key Ctrl+N. This shortcut will open a new workbook in Excel.

Opening an Existing Workbook

If you need to open an existing workbook, you can use the shortcut key Ctrl+O. This shortcut will open the Open dialog box, where you can select the workbook that you want to open.

Saving a Workbook

To save a workbook, you can use the shortcut key Ctrl+S. This shortcut will save the current workbook. If you haven't saved the workbook yet, you'll be prompted to enter a name for the workbook.

Printing a Workbook

To print a workbook, you can use the shortcut key Ctrl+P. This shortcut will open the Print dialog box, where you can select the printer and other printing options.

Undo an Action

If you need to undo an action, you can use the shortcut key Ctrl+Z. This shortcut will undo the last action that you performed.

Redo an Action

If you need to redo an action, you can use the shortcut key Ctrl+Y. This shortcut will redo the last action that you performed.

Insert a New Row

To insert a new row, you can use the shortcut key Ctrl+Shift+. This shortcut will insert a new row above the current row.

Insert a New Column

To insert a new column, you can use the shortcut key Ctrl+Shift+. This shortcut will insert a new column to the left of the current column.

Delete a Row

To delete a row, you can use the shortcut key Ctrl+-. This shortcut will delete the current row.

Delete a Column

To delete a column, you can use the shortcut key Ctrl+-. This shortcut will delete the current column.

Select a Cell

To select a cell, you can use the shortcut key Ctrl+. This shortcut will select the cell that you want to select.

Select a Range of Cells

To select a range of cells, you can use the shortcut key Ctrl+Shift+. This shortcut will select the range of cells that you want to select.

Select an Entire Row

To select an entire row, you can use the shortcut key Shift+Spacebar. This shortcut will select the entire row.

Select an Entire Column

To select an entire column, you can use the shortcut key Ctrl+Spacebar. This shortcut will select the entire column.

Select an Entire Worksheet

To select an entire worksheet, you can use the shortcut key Ctrl+A. This shortcut will select the entire worksheet.

Find a Value in a Worksheet

To find a value in a worksheet, you can use the shortcut key Ctrl+F. This shortcut will open the Find dialog box, where you can enter the value that you want to find.

Replace a Value in a Worksheet

To replace a value in a worksheet, you can use the shortcut key Ctrl+H. This shortcut will open the Replace dialog box, where you can enter the value that you want to replace.

Go to a Cell in a Worksheet

To go to a cell in a worksheet, you can use the shortcut key Ctrl+G. This shortcut will open the Go To dialog box, where you can enter the cell address that you want to go to.

Insert a hyperlink

To insert a hyperlink, you can use the shortcut key Ctrl+K. This shortcut will open the Insert Hyperlink dialog box, where you can enter the URL and the text that you want to display.

Create a chart

To create a chart, you can use the shortcut key F11. This shortcut will insert a new chart on a new worksheet.

View the formulas in a worksheet

To view the formulas in a worksheet, you can use the shortcut key Ctrl+`. This shortcut will toggle between the values and formulas in a worksheet.

Copy a cell

To copy a cell, you can use the shortcut key Ctrl+C. This shortcut will copy the contents of the cell.

Paste a cell

To paste a cell, you can use the shortcut key Ctrl+V. This shortcut will paste the contents of the cell.

Cut a cell

To cut a cell, you can use the shortcut key Ctrl+X. This shortcut will cut the contents of the cell.

Wrap text in a cell

To wrap text in a cell, you can use the shortcut key Ctrl+W. This shortcut will wrap the text in the cell.

Add borders to a cell

To add borders to a cell, you can use the shortcut key Ctrl+Shift+B. This shortcut will open the Borders dialog box, where you can select the type of border that you want to add.

Insert a comment in a cell

To insert a comment in a cell, you can use the shortcut key Ctrl+Shift+C. This shortcut will open the Insert Comment dialog box, where you can enter the comment that you want to insert.

Insert a hyperlink in a cell

To insert a hyperlink in a cell, you can use the shortcut key Ctrl+Shift+K. This shortcut will open the Insert Hyperlink dialog box, where you can enter the URL and the text that you want to display.

Insert a symbol in a cell

To insert a symbol in a cell, you can use the shortcut key Ctrl+Shift+S. This shortcut will open the Symbol dialog box, where you can select the symbol that you want to insert.

Insert a picture in a cell

To insert a picture in a cell, you can use the shortcut key Ctrl+Shift+P. This shortcut will open the Insert Picture dialog box, where you can select the picture that you want to insert.

Format a cell

To format a cell, you can use the shortcut key Ctrl+1. This shortcut will open the Format Cells dialog box, where you can select the format that you want to apply to the cell.

Create a table

To create a table, you can use the shortcut key Ctrl+T. This shortcut will insert a new table on the current worksheet.

Insert a row above the current row

To insert a row above the current row, you can use the shortcut key Ctrl+Shift+. This shortcut will insert a new row above the current row.

Insert a column to the left of the current column

To insert a column to the left of the current column, you can use the shortcut key Ctrl+Shift+

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.