ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Column width (https://www.excelbanter.com/excel-discussion-misc-queries/57798-column-width.html)

eenaj

Column width
 
I want to have two different column widths in one worksheet. Another words I
want Column A to be one width at the top of the worksheet, and column A to be
another width at the bottom of the worksheet without it effecting the top
column width. Is this possible?

FinRazel

Column width
 
Consider using the "Merge-and-Center" command (button on the formatting
toolbar next to "Align Right"). If you have highlighted one cell to the
right, this will cause the data in cell A1 to appear merged across A1 and B1.
Thus, the merged column above will appear to have a different width than
those below.

If this solution is not for you (there are several things wrong with it, for
example, it makes sorting difficult) you may want to try using a Pivot Table.
--
Anne Murray


"eenaj" wrote:

I want to have two different column widths in one worksheet. Another words I
want Column A to be one width at the top of the worksheet, and column A to be
another width at the bottom of the worksheet without it effecting the top
column width. Is this possible?


CLR

Column width
 
You can make this appear to happen by using Format Cells alignmentTab
Mergecells


Vaya con Dios,
Chuck, CABGx3



"eenaj" wrote:

I want to have two different column widths in one worksheet. Another words I
want Column A to be one width at the top of the worksheet, and column A to be
another width at the bottom of the worksheet without it effecting the top
column width. Is this possible?


Bob Phillips

Column width
 
No that is not possible. You might be able to frig it by merging either the
top or bottom rows with an adjacent column.

--

HTH

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


"eenaj" wrote in message
...
I want to have two different column widths in one worksheet. Another

words I
want Column A to be one width at the top of the worksheet, and column A to

be
another width at the bottom of the worksheet without it effecting the top
column width. Is this possible?





All times are GMT +1. The time now is 05:27 AM.

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