SOLVED

Hiding a column in table

%3CLINGO-SUB%20id%3D%22lingo-sub-1389296%22%20slang%3D%22en-US%22%3EHiding%20a%20column%20in%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1389296%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%20365.%20Is%20it%20possible%20to%20hide%20a%20column%20in%20a%20table%20without%20having%20to%20hide%20the%20entire%20column%20in%20the%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1389296%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-1389504%22%20slang%3D%22en-US%22%3ERe%3A%20Hiding%20a%20column%20in%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1389504%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F667871%22%20target%3D%22_blank%22%3E%40JARAllie%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20quite%20sure%20what%20you%20mean%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20hide%20the%20column%20in%20the%20table%20using%20the%20standard%20hide%20command.%3C%2FP%3E%3CP%3ENot%20sure%20what%20you%20mean%20by%20%22%26nbsp%3Bwithout%20having%20to%20hide%20the%20entire%20column%20in%20the%20sheet.%22%3C%2FP%3E%3CP%3ECan%20you%20clarify%20please%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPeter%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1389846%22%20slang%3D%22en-US%22%3ERe%3A%20Hiding%20a%20column%20in%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1389846%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F667968%22%20target%3D%22_blank%22%3E%40peteryac60%3C%2FA%3E%26nbsp%3B%20See%20the%20picture%20attached.%20Marked%20in%20Red%20is%20the%20table.%20I%20only%20want%20to%20hide%20the%20columns%20%25%20of%20max%20amount%2C%20Avg%20rate%20and%20Calc%20factor%20in%20the%20Table%20which%20is%20named%20%22Bidders%22.%20I%20do%20not%20want%20to%20delete%20the%20entire%20columns%20D%2C%20E%20and%20F%20as%20I%20would%20lose%20text%2C%20formulas%20that%20is%20outside%20the%20Table.%20You%20can%20delete%20Table%20columns%20however%20I%20have%20not%20been%20able%20to%20find%20out%20if%20you%20can%20Hide%20Table%20Columns%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1390225%22%20slang%3D%22en-US%22%3ERe%3A%20Hiding%20a%20column%20in%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1390225%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F667871%22%20target%3D%22_blank%22%3E%40JARAllie%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20hide%20columns%20by%20selecting%20the%20columns%20you%20want%20(D-F)%20right%20click%20and%20choose%20the%20hide%20option.%3C%2FP%3E%3CP%3EIt%20looks%20to%20me%20that's%20rows%201-2%20had%20headings%20and%20some%20of%20these%20are%20in%20merged%20cells%3F%20That%20might%20cause%20you%20a%20problem%20-%20you%20can%20unmerge%20and%20then%20hide%20your%20columns.%20That%20might%20help%3F%3C%2FP%3E%3CP%3EIf%20this%20is%20not%20the%20solution%20you%20need%20-%20you%20can%26nbsp%3B%20attach%20the%20spreadsheet%20(or%20part%20of%20it)%20and%26nbsp%3B%20I%20can%20have%20a%20look.%3C%2FP%3E%3CP%3Elet%20me%20know.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPeter.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1390273%22%20slang%3D%22en-US%22%3ERe%3A%20Hiding%20a%20column%20in%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1390273%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F667968%22%20target%3D%22_blank%22%3E%40peteryac60%3C%2FA%3E%26nbsp%3B%20Rows%201%20and%202%20are%20not%20part%20of%20the%20Table.%20The%20header%20row%20for%20the%20table%20is%20Row%203%20(A3%3AH3).%20I%20want%20to%20hide%20the%20Range%20D3%3AF4%2C%20not%20the%20entire%20Columns%20D%3AF%20which%20would%20remove%20some%20of%20the%20text%20that%20is%20above%20the%20table.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1390341%22%20slang%3D%22en-US%22%3ERe%3A%20Hiding%20a%20column%20in%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1390341%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F667871%22%20target%3D%22_blank%22%3E%40JARAllie%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYeah%20I%20surmised%20that%20rows%201-2%20were%20not%20part%20of%20the%20table.%3C%2FP%3E%3CP%3EYou%20can't%20hide%20part%20of%20a%20column%20-%20you%20have%20to%20hide%20the%20whole%20column.%20if%20you%20do%2C%20you%20will%20need%20to%20then%20deal%20with%20the%20headings%20in%20rows%201-2%20by%20moving%20them%20to%20the%20left%20so%20that%20they%20do%20not%20get%20hidden.%3C%2FP%3E%3CP%3ESo%20if%20you%20put%20the%20headings%20in%20cell(1%2C1)%20and%20then%20hide%20the%20columns%20the%20headings%20should%20still%20be%20ok.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehope%20that%20resolves%20it%20for%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPeter%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1390359%22%20slang%3D%22en-US%22%3ERe%3A%20Hiding%20a%20column%20in%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1390359%22%20slang%3D%22en-US%22%3EI'll%20do%20that%20for%20now%20then%20explore%20doing%20it%20with%20slicer%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Excel 365. Is it possible to hide a column in a table without having to hide the entire column in the sheet.

6 Replies
Highlighted

@JARAllie 

Hi

 

Not quite sure what you mean?

 

You can hide the column in the table using the standard hide command.

Not sure what you mean by " without having to hide the entire column in the sheet."

Can you clarify please?

 

thanks

 

Peter

Highlighted

@peteryac60  See the picture attached. Marked in Red is the table. I only want to hide the columns % of max amount, Avg rate and Calc factor in the Table which is named "Bidders". I do not want to delete the entire columns D, E and F as I would lose text, formulas that is outside the Table. You can delete Table columns however I have not been able to find out if you can Hide Table Columns

Highlighted

@JARAllie 

 

Hi

 

You can hide columns by selecting the columns you want (D-F) right click and choose the hide option.

It looks to me that's rows 1-2 had headings and some of these are in merged cells? That might cause you a problem - you can unmerge and then hide your columns. That might help?

If this is not the solution you need - you can  attach the spreadsheet (or part of it) and  I can have a look.

let me know.

 

Peter.

Highlighted

@peteryac60  Rows 1 and 2 are not part of the Table. The header row for the table is Row 3 (A3:H3). I want to hide the Range D3:F4, not the entire Columns D:F which would remove some of the text that is above the table.

Highlighted
Best Response confirmed by JARAllie (New Contributor)
Solution

@JARAllie 

 

Yeah I surmised that rows 1-2 were not part of the table.

You can't hide part of a column - you have to hide the whole column. if you do, you will need to then deal with the headings in rows 1-2 by moving them to the left so that they do not get hidden.

So if you put the headings in cell(1,1) and then hide the columns the headings should still be ok.

 

hope that resolves it for you.

 

Peter

Highlighted
I'll do that for now then explore doing it with slicer