Can't find table tools - and the help info is not helpful

%3CLINGO-SUB%20id%3D%22lingo-sub-1317045%22%20slang%3D%22en-US%22%3ECan't%20find%20table%20tools%20-%20and%20the%20help%20info%20is%20not%20helpful%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1317045%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20assign%20header%20rows%20to%20make%20an%20excel%20document%20accessible.%20I've%20watched%20tutorials%20and%20read%20the%20MS%20help%20docs%20and%20they%20all%20point%20me%20to%20the%20Table%20Tools%20tab.%20There%20is%20no%20Table%20Tools%20tab%20in%20my%20version%20of%20Excel%20that%20comes%20with%20Office%20365.%20The%20help%20article%20is%20relatively%20useless%20on%20this%20subject.%20Any%20advice%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1317045%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1317370%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20find%20table%20tools%20-%20and%20the%20help%20info%20is%20not%20helpful%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1317370%22%20slang%3D%22en-US%22%3E%3CP%3EHI%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F626853%22%20target%3D%22_blank%22%3E%40adammbs%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eto%20activate%20the%20table%20too%20you%20must%20first%20convert%20you%20date%20into%20Excel%20Tables%2C%20keep%20your%20data%20anywhere%20in%20the%20data%20and%20press%20CTRL%2BT.%20You%20will%20find%20the%20table%20ribbon%20is%20activated%20now.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1317603%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20find%20table%20tools%20-%20and%20the%20help%20info%20is%20not%20helpful%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1317603%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F626853%22%20target%3D%22_blank%22%3E%40adammbs%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDon't%20remember%20form%20which%20version%20of%20Excel%2C%20but%20Table%20Tools%20tab%20in%20ribbon%20is%20changed%20on%20Table%20Design.%20You'll%20find%20practically%20the%20same%20functionality%20under%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I'm trying to assign header rows to make an excel document accessible. I've watched tutorials and read the MS help docs and they all point me to the Table Tools tab. There is no Table Tools tab in my version of Excel that comes with Office 365. The help article is relatively useless on this subject. Any advice?

5 Replies

HI@adammbs 

 

to activate the table too you must first convert you date into Excel Tables, keep your data anywhere in the data and press CTRL+T. You will find the table ribbon is activated now.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

@adammbs 

Don't remember form which version of Excel, but Table Tools tab in ribbon is changed on Table Design. You'll find practically the same functionality under it.

This didn't work @Faraz Shaikh. It's impossible to find the Table tools. There is no Design tab in Office 365's Excel as others have mentioned Please escalate for assistance. 

@shannonf55104 

In modern interface that's Table Design tab which appears if only you stay within Table.

image.png

@adammbs 

The other thing you should see on the Home ribbon tab within the Styles Group is Format as Table.

 

image.png

This converts the selected Range to a Table and open Table Design

image.png

where I remove the filters and banded rows.