05-14-2020 06:32 AM
05-14-2020 09:42 AM
@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
05-14-2020 12:14 PM
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.
05-14-2020 12:31 PMSolution
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.