Once you have the basics of index pages, go crazy with different ways to present the list or the same list in different orders. Clicking on the link to a now-hidden workbook does nothing until the tabs is ‘unhidden’.
You can only make links to visible workbooks (ie that appear in the Insert Hyperlink dialog). Links to hidden tabs/workbooks don’t work. If you’d prefer to view another part of the workbook, change the cell reference accordingly.
The workbooks are listed under ‘Cell Reference’.Įxcel can’t link to a tab generally, it needs a specific cell reference so it inserts cell A1 of the workbook as a default. Then choose a cell reference or range in the workbook.Press Ctrl + K - the usual ‘Insert Hyperlink’ shortcut that works across all Office programs and beyond.In a cell, type the name of the tab or some other label then press enter to confirm the cell contents.We’ll just talk about internal links for a single workbook but the same principles apply to external links. Index page works across all devices and window widths Making a tab or worksheet index pageĮxcel can make hyperlinks to cells or ranges both within the current workbook and to other spreadsheets. The solution? An index page with clickable links to the tabs. A tab display option needs to work across the different Excel incarnations.
#Put editing group under home tab in word for mac android#
At one extreme is the narrow view of Excel for iPhone or Android phones. Those suggestions work to make a bit more space available but aren’t effective for many more worksheets.Īnother consideration is shared workbooks that can be opened by others on computers and devices wide and narrow. See Fit more tabs across an Excel workbook for some suggestions to squeezing more across the single line available. Make your own clickable list of workbook tabs in an Excel worksheet to workaround the small number of tabs that can fit in a single line. Thanks for joining us! You'll get a welcome message in a few moments.
0 kommentar(er)
