Excel 2007 Copy & Pasting Help

Nitefly

Nitefly

Nitefly

Man of Honour
Joined
24 Sep 2005
Posts
37,334
Hello all,

A few of us are miffed off in the office today with Excel 2007.

I have a spreadsheet open (let's say with 1000 rows) and filter it to show 200 rows. I then want to copy and paste these rows to a new worksheet without pasting over rows that have not been selected.

So for example, if my filter selects rows 56, 82 and 103, I want to paste these so that they appear as rows 1, 2 and 3 in the new worksheet.

On some of our computers it works without any problems, on others, like mine, it either pastes the whole wad (56, 57, 58.... 81, 82 etc) or pastes them as 56, 82 and 103, which can be expanded to include the whole wad with the filter. I'm baffled!

Can anybody help us out? Thanks :)
 
Select the cells to be copied by holding down Ctrl and then clicking each one individually (don't drag).

When you Paste them, they will paste in as you desire :)

Not the best solution if you have a lot of rows, I'll see if I can do better :D
 
div0 said:
Select the cells to be copied by holding down Ctrl and then clicking each one individually (don't drag).

When you Paste them, they will paste in as you desire :)

Not the best if you have a lot of rows, I'll see if I can do better :D
Click to expand...

Thanks for your reply - sadly, when I'm pasting a mahoosive chunk of rows, that might take a long time :p

I have however come up with the solution with the help of err... Office Help :o

You can select to paste visible cells only by selecting the Home tab, clicking find and select -> go to special -> click visible cells only.

Phew, got there in the end! Many thanks :)
 
You must log in or register to reply here.
Back
Top Bottom