Seleting A2 and A3 and left-click dragging will probably increment the numbers
to o,1,2,3,4,5,etc.

That's why I mentioned selecting A2 and A3 then right-click and drag then
release the button and "Copy Cells".

Or you could select A2 and A3 then select from A4 to A5600 and EditPaste

Whichever method you use....................

Do you have alternating 0's and 1's in A2:A5600?

If so, then you select the autofilter dropdown arrow in A1 and select 1 from the
choices.

All the rows with 0 should disappear and the rows with 1 will remain.

Select what's left from A2 downwards then EditDeleteEntire Row.

Now remove the Autofilter to see just the rows with 0 plus the top row.

To unmerge cells, FormatCellsAlignment. Uncheck "merge cells".


Gord

On Sat, 1 Mar 2008 19:44:00 -0800, Templar
wrote:

I've made backups. Something is not working right at all. I've tried it 20
times
I insert a new column as the first column
I enter xxxxxx on the title line
I enter 0 on line 2 and 1 on line three
Nothing happens when I right click, but when I left click I can drag all the
way
down to the final line entry (5,600) and they are properly highlighted.
I right click and hit copy
And then I get to authofilter.
An arrow box appears at the first entry of every column
But nothing happens.

By the way, if some cells are improperly merged in this database, is there
an easy command to delete the merge command?