#1   Report Post  
Posted to microsoft.public.excel.misc
eenaj
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
FinRazel
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changed column width keeps reverting back to original size David Boone Excel Discussion (Misc queries) 3 May 29th 05 01:22 PM
Is it possible to create one column with two different width? Dave H... Excel Worksheet Functions 1 February 21st 05 05:52 PM
Displaying column width and row height swirlygirl Excel Worksheet Functions 3 February 7th 05 09:53 PM
Change the width of a single column in a column chart Dave Charts and Charting in Excel 2 December 13th 04 07:25 PM
Column Width Deborah M Excel Discussion (Misc queries) 1 December 6th 04 04:27 PM


All times are GMT +1. The time now is 04:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"