Copying and Pasting
 

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

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

thinks its because of the hidden cells

please help

sorry if i sound so novice


--
davew21
------------------------------------------------------------------------
davew21's Profile: http://www.excelforum.com/member.php...o&userid=33040
View this thread: http://www.excelforum.com/showthread...hreadid=528542

Copying and Pasting
 

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.

"davew21" wrote in
message ...

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

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

thinks its because of the hidden cells

please help

sorry if i sound so novice


--
davew21
------------------------------------------------------------------------
davew21's Profile:
http://www.excelforum.com/member.php...o&userid=33040
View this thread: http://www.excelforum.com/showthread...hreadid=528542