Multiple Column Width in Single Column

[thechef]

Hey all,

I'm trying to set up a schedule template for use in CAD. I'm using Excel 2000 and want to make a few columns one width for say 4 rows, but then shrink the width for the remainder of the column. Thanks for any and all help. If this is too vague (or impossible) let me know.

 

[melone]

Can you use multiple colums and just merge across the cells that you want?

 

[thechef]

I've never merged two workbooks before, but I took a quick look at the Help file and it says that the two workbooks must be identical. Did I misunderstand you or the help file?

Here's a sketch of what I'm trying to accomplish. The problem is if XXX's and YYYY's are in column A, and Z and A are in Column B and C, 2/3 of the XXX's won't be visible. Am I making this more difficult on myself than it is?

XXXXXXXXXXXXXXXXXX
YYYYY ZZZZZ AAAAA

 

[palusa]

TC,
i don't think that what you asked is feasible in a straightforward way.

I would leave the 3 columns and would use for the many Xs a format such as "center across selection" to 'simulate' to be in a single cell, while formatting Ys Zs and As in their own cells.
Additionally, removing gridlines and adding properly the borders around the cells you could give a customized format to the schedule.

Hope it will help.

_LF

 

[thechef]

palusa,

thanks, didnt know about the center across selection format, will give that a try along with some border trickery as you suggested. i figured it wasnt too easy in a straightforward way, but thought maybe someone had a macro or something to that effect. thanks for the suggestions.

 

[melone]

No. I was talking about merging cells on a single workbook. For example:

Select cells A1, B1 and C1. Right click->Format Cells->Alignment->Merge Cells

You will still have 3 columns under the "A1" super cell....

 

[pmover]

slight correction to melone's last posting.

merging cells in a worksheet (not workbook).

otherwise, merging cells is likely the best option/solution.

good luck!
-pmover

 

[melone]

Sorry! PMOVER is correct.