Copying and Pasting

[davew21]

for example rows 1 -100 (doc1)
rows 1 -1000 (doc2)

if filtered doc2 and want to copy and paste same stuff from doc1 to do
2 but wont let me

thinks its because of the hidden cells

please help

sorry if i sound so novic

 

[Guest]

Hi

I use Ctrl+Shift+8 (or Ctrl+*). This will select all visible cells. You
can then copy them and paste them.
It's a bit of an odd combination but I use it loads ot times a day!

Hope this helps.
Andy.