View Single Post
 
Old 01-27-2010, 11:56 AM
miller.3276 miller.3276 is offline Windows XP Office 2007
Novice
 
Join Date: Jan 2010
Posts: 2
miller.3276 is on a distinguished road
Default 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
Attached Images
File Type: jpg excel column pic.jpg (62.7 KB, 16 views)
Reply With Quote