software

Is it possible to change the widths of columns from a certain row down in an
Excel worksheet?

You can't. Only an entire column can be resized.

However, you can merge cells to make a portion of a column WIDER (not a good
idea as it messes with sorting, range selection, etc).
Formatgt;Cellsgt;Alignmentgt;Merge cells

quot;Malcolmquot; wrote:

gt; Is it possible to change the widths of columns from a certain row down in an
gt; Excel worksheet?

Hi

You can't. The column is the same width all the way to the bottom. You can
merge cells (not recommended) and you can 'Center across selection' for
centering headings etc.

Andy.

quot;Malcolmquot; gt; wrote in message
...
gt; Is it possible to change the widths of columns from a certain row down in
gt; an
gt; Excel worksheet?
As said above, this isn't, quot;strictly speakingquot;, possible, although as with may things, it *is* with a little jiggery-pokery. Whether it is worth your while depends on how badly you want to do this.

Should you REALLY want to do this, here's what to do:

Create and save two files, let's say, quot;Book1quot; and quot;Book2quot;. Save them in the same directory (not actually necessary, but suggested).

Let's say Book1 contains the column sizings you want from Rows 1 to Row x. Size the column sizes according to what you want up to Row x.

Now, go to cell Ax 1 and perform the following menu clicks:
'Insert'-'Object'-'Create From File'-'Browse'-Select 'Book2'-'Insert'-
then, ensuring NEITHER the 'Link to file' NOR the 'Display as Icon' checkboxes are ticked, click OK.

This will insert Sheet1 of Book2 as a 'subform', if you like, within Sheet1(/or your active sheet) in Book1. It will be enclosed within a black frame - like a single black gridline around it. You will also see the light-grey gridlines within it. To change the column widths within this (and enter data and use it), double-click within the black frame, and this other sheet will appear in its own window. You may then size the columns for this 'subform'. Again, its range will start at A1 again so you will appear to be selecting column widths for the entire sheet - which you are for that subform. However, after finishing, you may close it, and your 'Book2' columns will appear within that frame that appeared in Book1 - differing column widths/row heights and all!

As with the suggestions above, these sorts of things are best avoided if at all possible - but there can be uses for them in certain scenarios.

MB


quot;BizMarkquot; wrote:

gt;
gt; As said above, this isn't, quot;strictly speakingquot;, possible, although as
gt; with may things, it *is* with a little jiggery-pokery. Whether it is
gt; worth your while depends on how badly you want to do this.
gt;
gt; Should you REALLY want to do this, here's what to do:
gt;
gt; Create and save two files, let's say, quot;Book1quot; and quot;Book2quot;. Save them
gt; in the same directory (not actually necessary, but suggested).
gt;
gt; Let's say Book1 contains the column sizings you want from Rows 1 to Row
gt; x. Size the column sizes according to what you want up to Row x.
gt;
gt; Now, go to cell Ax 1 and perform the following menu clicks:
gt; 'Insert'-'Object'-'Create From File'-'Browse'-Select 'Book2'-'Insert'-
gt; then, ensuring NEITHER the 'Link to file' NOR the 'Display as Icon'
gt; checkboxes are ticked, click OK.
gt;
gt; This will insert Sheet1 of Book2 as a 'subform', if you like, within
gt; Sheet1(/or your active sheet) in Book1. It will be enclosed within a
gt; black frame - like a single black gridline around it. You will also
gt; see the light-grey gridlines within it. To change the column widths
gt; within this (and enter data and use it), double-click within the black
gt; frame, and this other sheet will appear in its own window. You may then
gt; size the columns for this 'subform'. Again, its range will start at A1
gt; again so you will appear to be selecting column widths for the entire
gt; sheet - which you are for that subform. However, after finishing, you
gt; may close it, and your 'Book2' columns will appear within that frame
gt; that appeared in Book1 - differing column widths/row heights and all!
gt;
gt; As with the suggestions above, these sorts of things are best avoided
gt; if at all possible - but there can be uses for them in certain
gt; scenarios.
gt;
gt; MB
gt;
gt;
gt; --
gt; BizMark
gt;
YES!!! I have searched for this ability for a long time. This works and I
thank you


thank you so much, I have been trying to do this for so long and this works
great! You have solved my problem! Thank you, Thank you, Thank you
Diana

quot;BizMarkquot; wrote:

gt;
gt; As said above, this isn't, quot;strictly speakingquot;, possible, although as
gt; with may things, it *is* with a little jiggery-pokery. Whether it is
gt; worth your while depends on how badly you want to do this.
gt;
gt; Should you REALLY want to do this, here's what to do:
gt;
gt; Create and save two files, let's say, quot;Book1quot; and quot;Book2quot;. Save them
gt; in the same directory (not actually necessary, but suggested).
gt;
gt; Let's say Book1 contains the column sizings you want from Rows 1 to Row
gt; x. Size the column sizes according to what you want up to Row x.
gt;
gt; Now, go to cell Ax 1 and perform the following menu clicks:
gt; 'Insert'-'Object'-'Create From File'-'Browse'-Select 'Book2'-'Insert'-
gt; then, ensuring NEITHER the 'Link to file' NOR the 'Display as Icon'
gt; checkboxes are ticked, click OK.
gt;
gt; This will insert Sheet1 of Book2 as a 'subform', if you like, within
gt; Sheet1(/or your active sheet) in Book1. It will be enclosed within a
gt; black frame - like a single black gridline around it. You will also
gt; see the light-grey gridlines within it. To change the column widths
gt; within this (and enter data and use it), double-click within the black
gt; frame, and this other sheet will appear in its own window. You may then
gt; size the columns for this 'subform'. Again, its range will start at A1
gt; again so you will appear to be selecting column widths for the entire
gt; sheet - which you are for that subform. However, after finishing, you
gt; may close it, and your 'Book2' columns will appear within that frame
gt; that appeared in Book1 - differing column widths/row heights and all!
gt;
gt; As with the suggestions above, these sorts of things are best avoided
gt; if at all possible - but there can be uses for them in certain
gt; scenarios.
gt;
gt; MB
gt;
gt;
gt; --
gt; BizMark
gt;

Hi Bizmark - this was so simple, but so effective. It did EXACTLY what I
wanted, and have needed this ability for ages.
Cheers,quot;BizMarkquot; wrote:

gt;
gt; As said above, this isn't, quot;strictly speakingquot;, possible, although as
gt; with may things, it *is* with a little jiggery-pokery. Whether it is
gt; worth your while depends on how badly you want to do this.
gt;
gt; Should you REALLY want to do this, here's what to do:
gt;
gt; Create and save two files, let's say, quot;Book1quot; and quot;Book2quot;. Save them
gt; in the same directory (not actually necessary, but suggested).
gt;
gt; Let's say Book1 contains the column sizings you want from Rows 1 to Row
gt; x. Size the column sizes according to what you want up to Row x.
gt;
gt; Now, go to cell Ax 1 and perform the following menu clicks:
gt; 'Insert'-'Object'-'Create From File'-'Browse'-Select 'Book2'-'Insert'-
gt; then, ensuring NEITHER the 'Link to file' NOR the 'Display as Icon'
gt; checkboxes are ticked, click OK.
gt;
gt; This will insert Sheet1 of Book2 as a 'subform', if you like, within
gt; Sheet1(/or your active sheet) in Book1. It will be enclosed within a
gt; black frame - like a single black gridline around it. You will also
gt; see the light-grey gridlines within it. To change the column widths
gt; within this (and enter data and use it), double-click within the black
gt; frame, and this other sheet will appear in its own window. You may then
gt; size the columns for this 'subform'. Again, its range will start at A1
gt; again so you will appear to be selecting column widths for the entire
gt; sheet - which you are for that subform. However, after finishing, you
gt; may close it, and your 'Book2' columns will appear within that frame
gt; that appeared in Book1 - differing column widths/row heights and all!
gt;
gt; As with the suggestions above, these sorts of things are best avoided
gt; if at all possible - but there can be uses for them in certain
gt; scenarios.
gt;
gt; MB
gt;
gt;
gt; --
gt; BizMark
gt;