Forum Discussion
Hiding a column in table
Excel 365. Is it possible to hide a column in a table without having to hide the entire column in the sheet.
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
6 Replies
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
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
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.
