Tab - Move to the next cell in the same row.Ctrl+Enter - Complete a cell entry and move down one cell in the same column, but do not move to the next cell.Shift+Enter - Complete a cell entry and move up one cell in the same column.Enter - Complete a cell entry and move down one cell in the same column.The following shortcut keys will help you enter and edit data in cells: Ctrl+Page Down - Move one screen to the right in a worksheet.
Ctrl+Page Up - Move one screen to the left in a worksheet.Ctrl+End - Move to the last used cell on the worksheet.Ctrl+Home - Move to the beginning of the worksheet.Ctrl+F6 - Move to the next open workbook window.Ctrl+Tab - Move to the next open workbook.Alt+PgUp/PgDn - Move to the previous/next worksheet in the workbook.Ctrl+PgUp/PgDn - Move to the previous/next worksheet.Ctrl+arrow keys - Move to the edge of the current data region in the direction of the arrow keys.
The following shortcut keys will help you move around your worksheet and between different worksheets in a workbook: They will help you navigate around Excel, enter and edit data, and format cells. These are the shortcut keys that you will use most often. To make things easier, we've organized this guide by task, so you can quickly find the shortcut keys you need for the task at hand. For example, the shortcut keys for inserting a new row in a worksheet will not work when you are editing a cell. This means that the shortcut keys you use in one part of Excel may not work in another part. The first thing to know about Excel shortcut keys is that they are context-sensitive. We'll start with the most basic and essential shortcut keys and move on to more advanced and specific shortcut keys that will help you work with large data sets, perform complex calculations, and more. This guide covers all the essential shortcut keys that will help you work faster and more efficiently in Excel. These short cut keys should help you use Excel in a more efficient manner, making your work easier and help cut time off your Excel workload.Welcome to our complete guide to Microsoft Excel shortcut keys. Shortcut for Data EnteringĪlt + Enter – You can enter a new line in a cell while editing itĬtrl + D –You can copy the format of the cells and apply this formatting to a selected range of cells.Ĭtrl + –Insert the current date and time in your selected cell Place your pointer on your required row and type Shift + Space. Place your pointer on any cell of the required column and type Ctrl + Space. Shortcuts for Data SelectionĬtrl + A – Selects the whole text of your workbookĬtrl + Space – Selects the whole column. Similarly, Ctrl+ Pgdn takes to the previous sheet of your current page. Ctrl + PgUp takes you to the next sheet of your current page. The selected cells will become a table Shortcut for FormulasĬtrl + `- Lets you toggle between formulas and cell valuesĬtrl + ‘-Applies the formula of a selected cell to another cellį4 –Will show you the reference value of a cell Navigational ShortcutsĬtrl + Tab –Allows you to move between different workbooksĬtrl + End –Moves you to the last cell of your current workbookĬtrl + Home- Moves you to the first cell of your active workbookĬtrl + PgUp and Ctrl + PgDn – These shortcut keys help you navigate between different pages of a workbook. A cell is the smallest unit of area in an Excel spreadsheetĬtrl + V –Copies the content of the selected cells on to the clipboardĬtrl + P –Opens the print dialogue box Text Formatting ShortcutsĬtrl + 1 –Opens the format dialogue box for the cells of your workbookĬtrl + T –Chose your cells and press Ctrl + T. Ctrl + X – Cuts the content of the highlighted area in your workbook (cells).