Forum Discussion
Hiding a column in table
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
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.
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
- I'll do that for now then explore doing it with slicer