Show By J. Carlton Collins, CPA Q. I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of your Excel workbook's worksheet names as follows. From the Formulas tab, select Defined Names, Define Name to launch the New Name dialog box pictured below.
(Note: The workbook must be saved as an Excel Macro-Enabled Workbook file type in order to retain the Defined Name formula.)
Further, I recommend you insert a button on each worksheet that will return you to your table of contents, as follows:
About the author J. Carlton Collins () is a technology consultant, a conference presenter, and a JofA contributing editor. Submit a question Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to . We regret being unable to individually answer all submitted questions. How can I get a list of all sheets in Excel?First ensure that the Show sheet tabs is enabled. To do this, For all other Excel versions, click File > Options > Advanced—in under Display options for this workbook—and then ensure that there is a check in the Show sheet tabs box.
How do I get a list of all Google Sheets?Follow these steps to use the SHEETNAMES custom function to list all sheet names in Google Sheets.. Select any cell and type your header such as Sheet Names.. Select the cell below. In this example, cell C5 is selected.. Type =SHEETNAMES() and press the Enter key.. How do I print a list of tabs in Excel?The easiest approach is to right-click a worksheet tab, choose Select All Sheets, and then print normally to have the worksheets printed as a single print job. As an alternative you could also select File, Print, Settings, Print Entire Workbook to achieve the same result.
How do I export all sheets?By default, Excel will only export the active worksheet. If you have multiple worksheets and want to save all of them in the same PDF file, click Options in the Save As dialog box. The Options dialog box will appear. Select Entire workbook, then click OK.
|