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.
To create a new workbook, you can use the shortcut key Ctrl+N. This shortcut will open a new workbook in Excel.
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.
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.
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.
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.
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.
To insert a new row, you can use the shortcut key Ctrl+Shift+. This shortcut will insert a new row above the current row.
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.
To delete a row, you can use the shortcut key Ctrl+-. This shortcut will delete the current row.
To delete a column, you can use the shortcut key Ctrl+-. This shortcut will delete the current column.
To select a cell, you can use the shortcut key Ctrl+. This shortcut will select the cell that you want to select.
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.
To select an entire row, you can use the shortcut key Shift+Spacebar. This shortcut will select the entire row.
To select an entire column, you can use the shortcut key Ctrl+Spacebar. This shortcut will select the entire column.
To select an entire worksheet, you can use the shortcut key Ctrl+A. This shortcut will select the entire 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.
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.
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.
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.
To create a chart, you can use the shortcut key F11. This shortcut will insert a new chart on a new 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.
To copy a cell, you can use the shortcut key Ctrl+C. This shortcut will copy the contents of the cell.
To paste a cell, you can use the shortcut key Ctrl+V. This shortcut will paste the contents of the cell.
To cut a cell, you can use the shortcut key Ctrl+X. This shortcut will cut the contents of the cell.
To wrap text in a cell, you can use the shortcut key Ctrl+W. This shortcut will wrap the text in the 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.
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.
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.
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.
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.
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.
To create a table, you can use the shortcut key Ctrl+T. This shortcut will insert a new table on the current worksheet.
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.
To insert a column to the left of the current column, you can use the shortcut key Ctrl+Shift+