Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changed column width keeps reverting back to original size | Excel Discussion (Misc queries) | |||
Is it possible to create one column with two different width? | Excel Worksheet Functions | |||
Displaying column width and row height | Excel Worksheet Functions | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
Column Width | Excel Discussion (Misc queries) |