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

Hi,

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


hth
regards from Brazil
Marcelo

"Dumber than a pocket full of rocks" escreveu:

> 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

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
"Dumber than a pocket full of rocks" <(E-Mail Removed)> wrote in
message news:FBBC18AA-7352-4F05-BD18-(E-Mail Removed)...
> 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