Multiple Column Width in Single Column
Multiple Column Width in Single Column
(OP)
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.
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.





RE: Multiple Column Width in Single Column
RE: Multiple Column Width in Single Column
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
RE: Multiple Column Width in Single Column
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
RE: Multiple Column Width in Single Column
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.
RE: Multiple Column Width in Single Column
Select cells A1, B1 and C1. Right click->Format Cells->Alignment->Merge Cells
You will still have 3 columns under the "A1" super cell....
RE: Multiple Column Width in Single Column
merging cells in a worksheet (not workbook).
otherwise, merging cells is likely the best option/solution.
good luck!
-pmover
RE: Multiple Column Width in Single Column