Copying Data Without Hidden Values

O

Oscar

Please excuse a dumb question. I'm sure the answer is buried in the help
files somewhere, but I can't find it. I'm running Excel2002. I have a long
column of data with many hidden rows. I need to copy this column for a paste
operation, but I want to include only the active, visible fields. Every copy
process I've tried ends up pasting the hidden rows also. How do I exclude
the hidden rows from the copy process?
Thanks,
OC
 
N

Nikos Yannacopoulos

Oscar,

Select the column, then hit F5, click on Special, select Visible Cells Only,
OK, then Copy and Paste.

HTH,
Nikos
 
O

Oscar

Perfect! Thanks for your help!

Nikos Yannacopoulos said:
Oscar,

Select the column, then hit F5, click on Special, select Visible Cells Only,
OK, then Copy and Paste.

HTH,
Nikos
Click to expand...
 
Top