ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   having two separate column width controls on same worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/254619-having-two-separate-column-width-controls-same-worksheet.html)

Help appreciated!

having two separate column width controls on same worksheet
 
I have a work sheet - in top part, I want column widths to be one setting; in
bottom part, I want ability to have different column width setting...all on
one sheet. Can this be done? I have excel 2007.

Gord Dibben

having two separate column width controls on same worksheet
 
No it cannot be done.

Width is a property of the entire column.

If for presentation purposes only have a try with merged cells.

If you want to do more than look at the sheet...........do not use merged
cells or you will find a host of problems.


Gord Dibben MS Excel MVP

On Wed, 27 Jan 2010 13:21:02 -0800, Help appreciated!
wrote:

I have a work sheet - in top part, I want column widths to be one setting; in
bottom part, I want ability to have different column width setting...all on
one sheet. Can this be done? I have excel 2007.




All times are GMT +1. The time now is 08:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com