Forum Discussion
Excel for Mac 2016
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...
- agiuffreJun 16, 2021Copper Contributor
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.