Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How can I merge 5 cells from 3 rows (shaping a cross or U) in Excel2010? Everything I tried will merge a block of 9 cells together. How can I get around this?

share|improve this question
Are you needing this for display purposes only, or do you need it done this way to make formulas work? This seems like a very odd thing to need in a spreadsheet. – Jared Tritsch Oct 15 '12 at 22:36
It is for display purpose but the merged cells has to have merge charactrestic for coloring, boardering, data entering. – Moh Oct 15 '12 at 22:48
You cant break up a row/column you can do is a U shape with 2 columns have specified rows merged and then a row with a specified number of columns to complete the U. – GoldBishop Oct 16 '12 at 1:17

I don't think its possible to use cell merging to create shapes in that way, but if you are using it for display purposes, you can accomplish that in one of two ways:

  1. You can Overlay an Autoshape, using the Autoshapes toolbar. Instructions
  2. You can use Conditional formatting on the needed cells to apply coloring and data for that shape. That way, even though the cells are still considered separate cells, the visual effect will still be accomplished. Instructions
share|improve this answer
Thanks. That formating does the trick. – Moh Oct 15 '12 at 23:47
No problem. Please upvote and accept my answer then so I can get credit. – Jared Tritsch Oct 15 '12 at 23:49

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .