Forum Discussion

Lisa Carper's avatar
Lisa Carper
Copper Contributor
Apr 13, 2018

Excel for Mac 2016

I'm pretty new to Excel. Thanks for the help.   I do not have a "Table Tools" tab. I went to Excel>Preferences>Ribbon and can not find anything resembling Table Tools to add. Would someone be so ki...
community
Biedjee's avatar
Biedjee
Copper Contributor
Oct 01, 2020

Was this ever resolved? I can't find them anywhere on the Mac version of Excel. In Windows - they're there the instant you select a cell in a table. On the Mac, it simply doesn't seem to exist.

Even when searching for some of the functions in the ribbon under 'tell me' the topic is greyed out and can't be read...

 

 

agiuffre's avatar
agiuffre
Copper Contributor
Jun 16, 2021

Biedjee it's been a while, but just for the record and any other people who runs into this ... in Excel for Mac you won't have the Table tab unless you're actually working with a table. Just by filling cells it's not a table for Excel.

 

So, pick up your plain table and go to the first cell (probable the first header item) and then go to the main options (the ones you have at the top of the screen) Insert - Table, it will detect your entire table range. If you have headers keep checked the headers option and then press OK. Your old table will be transformed into a table you can work in Excel and then the gloriuos Table tab will appear for you.

Resources