Error--"try selecting only entire rows, entire columns, or justgroups of cells"

M

Michelle York

I've looked online for help and found the following. I tried following the
directions, but it doesn't seem to do anything. The original row shows 2
selected rows (even when I try to select only one to delete the other) and
when I follow these directions, it inserts 2 rows. :
That command cannot be used with selections that contain entire rows or
columns, and also other cells.
Try selecting only entire rows, entire columns, or just groups of cells.
CAUSE
This behavior occurs when all of the following conditions are true:

€ You merge cells in a column or row. -and-

€ You select the entire column or row in which you merged cells. -and-

€ The column or row that you select contains a merged cell that extends
over another column or row that you do not select. -and-

€ You click Columns or Rows on the Insert menu.
RESOLUTION
To resolve this behavior, select a single cell in the column or row in which
you merged cells (not the entire column or row), and click Columns or Rows on
the Insert menu.


Michelle York
Literacy Coach (1-5)
Highland Park Central Elementary School
Topeka, Kansas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top