Is there an option to quickly see a compact list of a table's column headers? Similar to the way you can get a list of all worksheets by right-clicking the left/right arrows next to the worksheets?
It's just a bit inconvenient having to scroll across a table with many columns when trying to find the name of a particular column.
Thanks!
You could probably pick a cell, say A1, and use Data Validation to list the column headers. But, you'd need VBA if you wanted to automatically select/go to the column. Should be doable though.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Ooh thanks! Data validation is a good option I hadn't considered.
I also noticed the Remove Duplicates feature shows all the column headers (Alt+A+M), for anyone else curious.
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks