Ask Your Question

what is a merged range and how can it be un-merged?

asked 2015-07-10 12:59:28 +0200

caliray gravatar image

Trying to delete a group of cells resulted in an error message that the selected cells are in a merged range. I know how to merge cells, and I never merged these, so how to I un-merge them? For that matter, how do I even know cells are merged when they appear to be single cells?

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2015-07-10 23:25:08 +0200

m.a.riosv gravatar image

When a merged celll is selected merge button is dark.

image description

edit flag offensive delete link more

answered 2015-07-10 19:02:20 +0200

Alex Kemp gravatar image

From the Help file:-

You can select adjacent cells, then merge them into a single cell. Conversely, you can take a large cell that has been created by merging single cells, and divide it back into individual cells.

Splitting Cells:-

  1. Place the cursor in the cell to be split.
  2. Choose Menu:Format Merge Cells Split Cells

If this helps then please tick the answer (✔).

edit flag offensive delete link more

answered 2015-07-11 07:25:54 +0200

pierre-yves samyn gravatar image

Hi - Another one...

Right click the selection, context menu offers Split Cells if it contains merged cells


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-07-10 12:59:28 +0200

Seen: 2,256 times

Last updated: Jul 11 '15