#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Hi there,
I have a proposal for a solution. (the English menu commands are translated from Swedish and might therefore not be 100% equal to the actual text in English Excel). Create a textbox that goes over several columns. Right click on the textbox and select "Format...". Now select Select "Properties" and then the radio button "Don't move or change size when with cells". + OK. If you donä't have a constant text in the textbox, you can link it to a cell. Mark the textbox, click the formula field an write (example): =Sheet1!M1 Now you can hide/unhide without any change of the textbox. See my attached example. Let me know if this helps you! Kind regards from snowy Sweden! Bjorn |
#3
|
|||
|
|||
Great idea. This is a work around that I can use ... thanks
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Worksheet copying? | markg2 | Excel | 4 | 01-07-2010 10:08 AM |
How do I make seperate user accounts/files | DramaQueenLucy | Outlook | 1 | 06-05-2009 07:38 AM |
Header - seperate chapter, continue page number | Cpt Black | Word | 0 | 02-03-2009 06:45 AM |
TRANSFER DATA TO NEW WORKSHEET | BOBN | Excel | 0 | 11-08-2007 10:34 PM |
click a cell to go to a worksheet | victor | Excel | 0 | 10-27-2006 02:57 PM |