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%20noopener%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%20noopener%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
Highlighted
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?

5 Replies
Highlighted

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?

 

Highlighted

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

Highlighted

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

Highlighted

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

Highlighted

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