ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Are different column widths possible on the same worksheet? (https://www.excelbanter.com/excel-worksheet-functions/56052-different-column-widths-possible-same-worksheet.html)

yinone

Are different column widths possible on the same worksheet?
 


Bob Phillips

Are different column widths possible on the same worksheet?
 
Absolutely.

Either set them using FormatColumnWidth, or just move the cursor to the
right of the cell header, where it changes to a black cross, and click and
drag.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"yinone" wrote in message
...




Don Guillett

Are different column widths possible on the same worksheet?
 
Of course, had you tried you would have known the answer without asking.
However, you may NOT have part of the column one width and another part of
the SAME column a different width. Perhaps that was really your question.

--
Don Guillett
SalesAid Software

"yinone" wrote in message
...




Gord Dibben

Are different column widths possible on the same worksheet?
 
Unless you mean different widths within the same column.

Width is a property of the entire column and cannot be changed at random areas
in that column.


Gord Dibben Excel MVP

On Thu, 17 Nov 2005 19:17:53 -0000, "Bob Phillips"
wrote:

Absolutely.

Either set them using FormatColumnWidth, or just move the cursor to the
right of the cell header, where it changes to a black cross, and click and
drag.



Bob Phillips

Are different column widths possible on the same worksheet?
 
Yes I know, but the OP's sparse did not suggest that was the question.

Bob


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Unless you mean different widths within the same column.

Width is a property of the entire column and cannot be changed at random

areas
in that column.


Gord Dibben Excel MVP

On Thu, 17 Nov 2005 19:17:53 -0000, "Bob Phillips"
wrote:

Absolutely.

Either set them using FormatColumnWidth, or just move the cursor to the
right of the cell header, where it changes to a black cross, and click

and
drag.





Gord Dibben

Are different column widths possible on the same worksheet?
 
Bob

My post was directed towards OP, not yourself.

Sorry I tacked onto your post.


Gord Dibben Excel MVP

On Thu, 17 Nov 2005 20:56:55 -0000, "Bob Phillips"
wrote:

Yes I know, but the OP's sparse did not suggest that was the question.

Bob


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Unless you mean different widths within the same column.

Width is a property of the entire column and cannot be changed at random

areas
in that column.


Gord Dibben Excel MVP

On Thu, 17 Nov 2005 19:17:53 -0000, "Bob Phillips"
wrote:

Absolutely.

Either set them using FormatColumnWidth, or just move the cursor to the
right of the cell header, where it changes to a black cross, and click

and
drag.





yinone

Are different column widths possible on the same worksheet?
 
Yes, my question was not very clear but I did mean within the same column.
Thankyou for the responses' everyone, this forum was very helpful!

"Gord Dibben" wrote:

Unless you mean different widths within the same column.

Width is a property of the entire column and cannot be changed at random areas
in that column.


Gord Dibben Excel MVP

On Thu, 17 Nov 2005 19:17:53 -0000, "Bob Phillips"
wrote:

Absolutely.

Either set them using FormatColumnWidth, or just move the cursor to the
right of the cell header, where it changes to a black cross, and click and
drag.





All times are GMT +1. The time now is 03:57 PM.

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