Copying Data Without Hidden Values

  • Thread starter Thread starter Oscar
  • Start date Start date
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
 
Oscar,

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

HTH,
Nikos
 
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...
 
Back
Top