1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Tip: Always show Table Name

Someone told me about this here a long while back, but for whatever reason I slept on it and my jaw dropped when I finally tested it out today.

If you use Excel Tables, go to Table Design > right click on Table Name and Add to your Quick Access Toolbar. I assumed that it'd just add an icon to the quick access bar but it straight up just adds the field to the bar!

https://preview.redd.it/newyurjsythg1.png?width=516&format=png&auto=webp&s=f58b4afa15384af41e90bc528bd78279826eca33

Now you can use Alt + [numeric position of the quick access item], (e.g. Alt + 1 in screenshot after I moved it to the front) to access it, but more importantly you can always see the table name without ever having to do Alt + JTA!

I'm sorry I don't remember the user who brought this to my attention and they're too far back in my notification history to find, but thank you so much for sharing this!

submitted by /u/alexia_not_alexa
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#rows.com
#Table Name
#Excel Tables
#Quick Access Toolbar
#Table Design
#Alt key
#field
#access item
#numeric position
#bar
#icon
#screenshot
#right click
#JTA
#notification history
#user