Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
537 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers 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
Search our website
We also send out useful tips in a monthly email newsletter ...
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:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.