No it will fill about 3 rows down. When I click off of it, it will continue to fill color where ever I click on the sheet, simlar as if I was highlighting.
There are about 3 or 4 pages of a rather simply document. We have a construction company so this stuff is not that very complex. There are about 4 columns across & about 150 rows down total.
I did what you explained, it has taken care of the color highlighting, although have a bit of problems with the box out lines borders disppearing when I proceed to copy a group of rows.