![]() |
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? |
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? |
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? |
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