Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 merge....best 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
add comment

1 Answer

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.