2 cells inside of one

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dumber than a pocket full of rocks - 03 Jul 2006 23:00 GMT

I entered a row into a template sheet. Where there should be 1 cell there is
now 2 cells in one of the rows and when I drag down to auto fill, it is not
allowing to enter. I get the error message "this operation requires the
mergered cells to be identically sized" I have adjusted the hight its the
width I can't expand to make it one cell

Reply to this Message

Marcelo - 03 Jul 2006 23:15 GMT

Hi,

try to merge the cells before drag.
or copy and paste.

hth
regards from Brazil
Marcelo

> I entered a row into a template sheet. Where there should be 1 cell there is
> now 2 cells in one of the rows and when I drag down to auto fill, it is not
> allowing to enter. I get the error message "this operation requires the
> mergered cells to be identically sized" I have adjusted the hight its the
> width I can't expand to make it one cell

Reply to this Message

Otto Moehrbach - 03 Jul 2006 23:20 GMT

The 2 cells are merged. I take it that you don't want them merged. To
unmerge them, select that cell (looks like 2 cells), then do Format -
Cells - Alignment tab, uncheck "Merge cells". HTH Otto

> I entered a row into a template sheet. Where there should be 1 cell there
> is
[quoted text clipped - 3 lines]
> mergered cells to be identically sized" I have adjusted the hight its the
> width I can't expand to make it one cell

Reply to this Message

Rate this thread: