×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Multiple Column Width in Single Column

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.

RE: Multiple Column Width in Single Column

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

RE: Multiple Column Width in Single Column

(OP)
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

RE: Multiple Column Width in Single Column

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

RE: Multiple Column Width in Single Column

(OP)
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.

RE: Multiple Column Width in Single Column

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....

RE: Multiple Column Width in Single Column

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

RE: Multiple Column Width in Single Column

Sorry!  PMOVER is correct.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources