Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Cell Width WITHOUT changing Column width dww701 Excel Discussion (Misc queries) 1 January 12th 09 10:52 PM
How to make cell width different than the column width it lies in John Excel Discussion (Misc queries) 2 September 11th 06 10:41 PM
Protecting Controls in a worksheet Dire straits Excel Discussion (Misc queries) 2 August 12th 06 03:46 AM
Multiple Option Controls w/in Worksheet uberbetty Excel Worksheet Functions 1 July 30th 06 11:33 PM
Vary column width and row height in the same worksheet Tess Excel Discussion (Misc queries) 1 August 4th 05 03:39 PM


All times are GMT +1. The time now is 09:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"