562 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
The hidden door to extra functions in Excel
Part one of a six-part series of blogs
Did you know that you could combine range names and legacy Excel 4 functions to list out the worksheets or range names in your workbook - wthout using macros? I didn't either - here's how to do this, and much more!
I was teaching a course a couple of days ago, and somebody asked me if you could use a formula to take the worksheets in a workbook ...
My model contains these worksheets.
... and list these out with hyperlinks:
When you click on any worksheet Excel will take you to it.
I knew you could use the CELL function to get at the name of the current worksheet, but listing all of the names? That's impossible, I said. Except ... it isn't, because you can use Excel 4 functions to do amazing things like this in Excel, as I now know!
Thanks to Jenny Manning for showing me that this was possible. Be warned that even though none of the solutions in this blog requires you to write macros, you now (as of January 2022) need to save your workbooks with the .xlsm file extension (because they contain Excel 4 macro functions), and you may well need to add the workbook containing the functions to your list of trusted files. There's also no guarantee that Microsoft will continue to support Excel 4 macros in the future, of course ...
|Parts of this blog|
Some other pages relevant to the above blogs include:
25 Aytoun Street