![]() ![]() To do so, we select the range of the data, and copied the link. Suppose we have a worksheet with monthly expenses of a small firm and we want to create a link to that we can jump to that range quickly. You’ll be able to go directly to the cell/range by clicking the link. Paste the link that you’ve copied and give it a name.You also press Ctrl+K to open the option for inserting the link. Select the cell that you want to put the link, right-click and select Insert link.The link will be copied to the clipboard. Right click → View more cell actions→ Get link to this cell (or range, if you’ve selected a range).Select the cell or range you want to jump to.You can create a hyperlink in Google Sheets and jump to cell by clicking that link by following these steps: ![]() We can create a table of contents listing the worksheets and add hyperlinks to them which will take us directly to the spreadsheet. We can then click the cell that we’ve inserted the link and this will take us to the cell or the range that we’ve hyperlinked. How to Jump to cell in Google Sheets by creating a linkĪnother handy way in Google Sheets to jump to a cell or range is by creating a link to the cell or the range. You can also press Alt+E+G simultaneously to accomplish the same. Once the keyboard shortcuts option has been enabled, you can press F5 (or Fn+F5) to bring up the go feature. Toggling on the shortcut to jump to cell in Google Sheets On the Keyboard shortcuts window, toggle on the Enable compatible spreadsheet shortcuts at the bottom left. Enabling keyboard shortcut to jump to cell in Google Sheets Click the Help tab and select Keyboard shortcuts. Jumping to range in Google SheetsĪlternatively, you can use keyboard shortcuts for Google Sheets to jump to cell or range using the Go to range feature.īefore you can use shortcuts in Google Sheets, however, you need to enable compatible spreadsheets shortcuts if you haven’t already done so. For example, B50:D65 to jump to that range. To jump to a range of cells, specify the range as you do in a formula. For example, if you want to jump to the cell A101, simply type in that cell number and hit Enter. Enter the cell number or the range that you want to jump to. On selecting Go to range, a small search bar will appear on the top right corner of the spreadsheet. Using Go to range feature to jump to cell in Google Sheets You can also open the search option by pressing the Alt key and the forward slash key simultaneously ( Alt+/). In order to use this feature, click the Help tab and search for Go to range. ![]() Jump to cell in Google Sheets using the Go range to feature Jump to cell in Google Sheets using keyboard shortcuts.How to Jump to cell in Google Sheets by creating a link.Jump to cell in Google Sheets using the Go range to feature. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |