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. When you insert a column in a worksheet what happens to the formulas you already entered?When you insert a column in a worksheet, what happens to formulas you already entered? Excel updates their cell references to reflect the new layout. You have cut the range A1:A5, and want to paste it to C1:C5.
What does the icon look like to add a new worksheet to the current workbook?The icon is a circle with a plus sign that appears to the right of the last sheet tab. It also looks like an aerial view of a Phillips-head machine screw. When you click this icon, a new worksheet is added to the right of the active sheet.
Which of the following commands is used to insert a cell into a worksheet?Excel Lesson 6 Review. What is the correct formula to insert the date into a cell?Insert a date or time whose value is updated. |