vistakasce.blogg.se

Click the down arrow in the Name box (you will need to have named cells or ranges in the workbook).If you have created a named cell or range, you can jump to it using the Name box (in the left area of the Formula bar): Move to a named cell or range using the Name box

Click or tab to the named cell or range (such as Toronto) you wish to jump to and press Enter.ġ0.Any named cells or ranges will appear in the dialog box. Excel will suggest the current cell or range as an absolute reference and the current sheet. Press Ctrl + F3 (some users may need to press Ctrl + Fn + F3).To name a cell or range of cells and then jump to it: If you have a cell or range of cells on a sheet that you want to jump to quickly, you can name the cells or ranges and then quickly jump to them. Move to a named cell or range using the Go To dialog box Repeat to move right to the next area with data. To move left by data area, press Ctrl + left arrow. To move right by data area, press Ctrl + right arrow. Repeat to move down to the next area with data. To move down by data area, press Ctrl + down arrow. Repeat to move up to the next area with data. To move up by data area, press Ctrl + up arrow. Press Ctrl + Page Down to move to the previous sheet in the current workbook. Press Ctrl + Page Up to move to the next sheet in the current workbook. Type the cell reference in the reference area and press Enter to go to that cell. Press Ctrl + G and the Go To dialog box appears. Pres Ctrl + Home to move to the top left cell in the current worksheet below the frozen titles which is usually cell A1. Recommended article: 10 Timesaving Selection Shortcuts in Microsoft Excel Worksheetsĭo you want to learn more about Excel? Check out our virtual classroom or live classroom Excel courses > 1. In this article, we've put together a great list of navigation shortcuts to help you be more productive with Excel. You can use keyboard shortcuts to jump to the beginning or end of your worksheet and move up or down by ranges of data. In Microsoft Excel, you can save lots of time if you can move around quickly in your worksheets and workbooks. Navigate Quickly using Keyboard Shortcuts in Microsoft Excelīy Avantix Learning Team | Updated April 5, 2021Īpplies to: Microsoft ® Excel ® 2010, 2013, 2016, 2019 and 365 (Windows)