Seperate Column widths in one worksheet
Is there a way to have separate columns widths in the same document?
Ex. I would like to have column A have a width of 9 for the first 10 rows, then have a width of 3 in the remaining rows of the document. (this is a simplified example).
I am aware that I can merger two cells at the top in order to get the full 9 width but this will not accomplish what I need. The document is a template that has information at the top and a chart below (see image attached). For certain projects I will have to unhide columns E, F, G, & H. The problem is when I unhide these columns the information in row 2 is distorted due to the additional columns.
The solution I am considering but have not been able to accomplish is inserting an excel spreadsheet within an excel spreadsheet. The information at the top will be on the first spreadsheet with the one set of column widths and then the chart on an embedded spreadsheet with the hiden columns. The catch is that I don’t want this to be a link, I want it to be an embedded spreadsheet.
Hopefully someone can understand what I am asking and help me
|