Excel for Mac 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-182554%22%20slang%3D%22en-US%22%3EExcel%20for%20Mac%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-182554%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20pretty%20new%20to%20Excel.%20Thanks%20for%20the%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20do%20not%20have%20a%20%22Table%20Tools%22%20tab.%20I%20went%20to%20Excel%26gt%3BPreferences%26gt%3BRibbon%20and%20can%20not%20find%20anything%20resembling%20Table%20Tools%20to%20add.%20Would%20someone%20be%20so%20kind%20as%20you%20tell%20me%20exactly%20what%20I%20need%20to%20do%20to%20find%20and%20add%20Table%20Tools%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-182554%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECommunity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-183462%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20Mac%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-183462%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Lisa%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20Table%20Tools%20tab%20is%20a%20type%20of%20%3CSTRONG%3Econtextual%20tab%3C%2FSTRONG%3E%20that%20appears%20only%20if%20there%20is%20a%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcreate-or-delete-an-excel-table-e81aa349-b006-4f8a-9806-5af9df0ac664%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Etable%3C%2FA%3E%20in%20the%20worksheet%20and%20the%20selected%20cell%20is%20within%20the%20boundaries%20of%20the%20table.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ESo%20if%20you%20select%20another%20cell%20outside%20the%20table%20boundaries%2C%20the%20Table%20Tools%20tab%20will%20disappear!%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3EHope%20that%20helps%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EHaytham%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-183258%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20Mac%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-183258%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20moving%20this%20question%20to%20the%20Excel%20space%20for%20better%20visibility.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-183046%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20Mac%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-183046%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20Table%20Tools%20is%20dynamic%20-%20it%20appears%20after%20you%20create%20the%20table%20and%20focus%20on%20any%20cell(s)%20within%20the%20table%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-182634%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20Mac%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-182634%22%20slang%3D%22en-US%22%3E%3CP%3ENot%20a%20feature%20I%20am%20familiar%20with%20but%20did%20you%20see%20the%20guidance%20here%3F%20This%20shows%20have%20to%20access%26nbsp%3BTable%20Tools%2C%20worth%20trying%20anyway%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-ie%2Farticle%2Fwhere-are-the-table-tools-2afc4727-7bba-4d4e-b9bf-43ab5f995745%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EWhere%20are%20the%20Table%20Tools%3F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 kind as you tell me exactly what I need to do to find and add Table Tools?

6 Replies

Not a feature I am familiar with but did you see the guidance here? This shows have to access Table Tools, worth trying anyway: 

 

Where are the Table Tools?

 

Yes, Table Tools is dynamic - it appears after you create the table and focus on any cell(s) within the table

I'm moving this question to the Excel space for better visibility. 

Hi Lisa,

 

The Table Tools tab is a type of contextual tab that appears only if there is a table in the worksheet and the selected cell is within the boundaries of the table.

So if you select another cell outside the table boundaries, the Table Tools tab will disappear!

 

Hope that helps

Haytham

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...

 

 

@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.