The worksheet names will fill the cells to the right. To test your new name type =SheetList into a cell. You won’t find it in the Formulas tab but it works fine … with some conditions we’ll mention in a moment. It’s an old Excel function that’s still necessary and available but not part of the current Excel function list. Go to Formulas | Define Name | Define Name … The tricky bit is making the initial list of tab names.Ĭreate a Define Name with a function which grabs the list of worksheets and puts them into an array. We’ll break it down so you can understand how the whole thing comes together. The steps are straightforward, even if you don’t understand the functions and formulas involved. There’s no direct function to do it and the current method relies on a very old and officially obsolete Excel function (which has no modern equivalent for reasons passing understanding).
Making a list of worksheets is a thing you might expect to be easy but is almost ludicrously intricate. Now we’ll take the next step and make an automatic list of worksheets that will update as the workbook changes. We’ve already talked about fitting more tabs on the screen or making a manual list of tabs/worksheets.
Thanks for joining us! You'll get a welcome message in a few moments.Īn automatically updated list of all worksheets or tabs in Excel but there are ‘gotchas’ which aren’t often mentioned.
