#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default Col widths

Is there a way to have COL A rows 1 to 10 at a width of 15
and the same col(a) be at a width of 20 from row 11 to 20?Thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 536
Default Col widths

On Monday, April 15, 2013 4:24:50 PM UTC-7, pcorcele wrote:
Is there a way to have COL A rows 1 to 10 at a width of 15

and the same col(a) be at a width of 20 from row 11 to 20?Thanks


You may be able to fake it with merged cell for the 11 to 20. Be careful, could cause you some problems.

Regards,
Howard

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default Col widths

On Monday, April 15, 2013 7:24:50 PM UTC-4, pcorcele wrote:
Is there a way to have COL A rows 1 to 10 at a width of 15

and the same col(a) be at a width of 20 from row 11 to 20?Thanks


You are right did not work very well.. as a matter of fact I could not make that work at all but that for the try.
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default Col widths

On Monday, April 15, 2013 7:24:50 PM UTC-4, pcorcele wrote:
Is there a way to have COL A rows 1 to 10 at a width of 15

and the same col(a) be at a width of 20 from row 11 to 20?Thanks


You are right did not work very well.. as a matter of fact I could
not make that work at all but that for the try.


Worked for me...

A:B col width = 10
A11:B11 merge; repeat to A20:B20

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


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
Bar Widths Paul Peterson - Velox Consulting, LLC Charts and Charting in Excel 2 November 25th 08 04:44 AM
how do i set column widths lpdarspe Excel Programming 9 November 25th 07 06:15 PM
Column widths are the same but look different. Suzan Excel Discussion (Misc queries) 0 December 29th 05 04:29 PM
Row widths Brurobiney Excel Discussion (Misc queries) 5 September 7th 05 04:30 PM
Column widths jrpOR Excel Worksheet Functions 2 August 6th 05 01:44 AM


All times are GMT +1. The time now is 01:56 AM.

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"