Copying Data Without Hidden Values

's Computer Specifications

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

's Computer Specifications

Oscar,

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

HTH,
Nikos

"Oscar" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>

's Computer Specifications

Perfect! Thanks for your help!

"Nikos Yannacopoulos" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Oscar,
>
> Select the column, then hit F5, click on Special, select Visible Cells
Only,
> OK, then Copy and Paste.
>
> HTH,
> Nikos
>
> "Oscar" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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
> >
> >
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I avoid copying data from hidden rows/columns?	=?Utf-8?B?RnJlZA==?=	Microsoft Excel Misc	2	22nd Feb 2008 08:43 PM
Problem copying from a hidden worksheet (data is copied, but alsoadditional sheet info)	giancarp@googlemail.com	Microsoft Excel Programming	8	31st Jan 2008 06:26 PM
How do I exlude hidden cells when copying data	=?Utf-8?B?QnVsbHkgUmFt?=	Microsoft Excel Misc	1	1st Aug 2005 03:54 PM
How do I ignore values while copying from hidden rows?	=?Utf-8?B?TWF5YW5r?=	Microsoft Excel Worksheet Functions	1	19th Jul 2005 02:48 PM
Copying data without hidden rows.	=?Utf-8?B?Q3ViZSBGYXJtZXI=?=	Microsoft Excel Worksheet Functions	2	27th Apr 2005 03:17 PM