Anywhere in the workbook, insert a Text Box (from the Insert tab's Shapes menu), label it Return to the Table of Contents, and format the button to your desire.
This named location will be the cell where the navigational button created in the steps below will lead. Start by placing your cursor at the top of the table of contents and in the Name Box (located directly above column A), type TOC and press the Enter key. The advantage of this alternative approach is that the separate column of hyperlinks (such as column C in the example above) is not necessary, but the disadvantage is that each hyperlink must be applied one at a time.)įurther, I recommend you insert a button on each worksheet that will return you to your table of contents, as follows: (As an alternative, you could instead select each name in the table of contents one at a time and press Ctrl+K to apply a hyperlink directly to each worksheet name. You can always ask an expert in the Excel Tech Community or get support in the Answers community.As a result, you will then be able to click each link to jump to the various worksheets listed in your table of contents. Select the cell or cells that you want to link to and press Enter.Įxcel will return to the original worksheet and display the values from the source worksheet.
Switch to the worksheet that contains the cells that you want to link to. If you want to use a function, such as SUM, then type the function name followed by an opening parenthesis. Select the cell or cells where you want to create the external reference. To use the link in a formula, type = in front of the link, choose a function, type (, and then type ) after the link.Ĭreate a link to a worksheet in the same workbook If you change it, it will automatically change in the destination workbook when you refresh your browser window. Select the cell where you want to place the linked data, then go to Home > Clipboard > Paste > Paste Link.Įxcel will return the data you copied from the source workbook. Switch to the destination workbook, and then click the worksheet where you want the linked data to be placed. Press Ctrl+C or go to Home > Clipboard > Copy. In the source workbook, select the cell or cells you want to link. Open the workbook that will contain the external reference (the destination workbook, also called the formula workbook) and the workbook that contains the data that you want to link to (the source workbook, also called the data workbook). Create an external reference between cells in different workbooks
0 kommentar(er)
