Copy entire Column B and paste to Column I

I am working on a spreadsheet in Excel 2007 and have come upon a problem that I am unable to solve.

I am attempting to copy Column B, which is entirely rows of names of people, and paste it into a new column I

When I SELECT and COPY text there are little moving lines that appear around the selected text.
They look like marching ants.

In my current spreadsheet, when I SELECT and COPY Column B, each row of text in the column is selected individually (multiple selections), rather that the entire column being selected with the "marching ants" around the perimeter of the column.

I did try to do a print screen of this but the moving ants don't show.

When I go to PASTE, I get this error box:

[That command cannot be used on multiple selections]

Unfortunately I can't seem to select the column in a single selection.

I'm pretty sure that I have just pushed a wrong key and reset some feature of Excel 2007 to cause this problem.
Can somebody please help me with this?
I am stuck.

Peggy

Hi Peggy,

Are you using an autofilter?

If you're filtering, that shouldn't cause that error message. What it will do is paste the information that you've filtered into a column consecutively. It won't miss the rows that you've filtered out.

That problem usually occurs when you have two different sections copied that are different sizes. E.G. A2:C2 and A5: F6. Try and copy that and you'll get that error because the two sections have different widths.

The other possible solution is save the book, shut it down and start it up again. It's a microsoft solution but it works sometimes.

Or if you're using "Alt and ;" to select the blank filtered range in order to get around my first point above.

It doesn't work in excel.

The filtering was the problem. I had filtered out and hidden any row with a value of less than 6. They were all still there and causing the issue.
I am now going through and deleting all of those rows.
Is there an easy way to do that?
There are thousands of them.

Thanks so much for your kind help Homeslice01.

Peggy

The easiest way I know is:

First... save your work so you don't lose everything and blame me.

Apply a filter on the column
Omit all other values above 6. (So select all so that no filter is applied then tick 0-6)
Click on the first cell in the column and drag down for all
Hold Alt and ;
Then delete.