copy/paste with hidden rows don't want hidden parts to paste

's Computer Specifications

I want to copy information in a column that has hidden rows and do not want
the hidden information to paste. Is there any way to copy only what is
showing?

's Computer Specifications

Highlight what you want to copy
Press Ctrl+G
Click the Special button
Select Visible Cells Only
Click OK
Now only the visible cells in your original selection are selected.

robynne wrote:
> I want to copy information in a column that has hidden rows and do not want
> the hidden information to paste. Is there any way to copy only what is
> showing?

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Want to Copy and paste to new sheet range except hidden rows.	HammerJoe@gmail.com	Microsoft Excel Programming	4	16th Jun 2008 02:24 PM
Re: subtotal copy-paste and delete hidden rows	Dave Peterson	Microsoft Excel Misc	0	12th Dec 2006 03:26 PM
copy a page with hidden rows and only paste what is showing	=?Utf-8?B?d3lvY293Ym95?=	Microsoft Excel Misc	2	18th Nov 2006 06:44 PM
copy and paste hidden rows	tracykrulich	Microsoft Excel Worksheet Functions	1	13th Oct 2005 05:11 PM
Copy and Paste hidden rows	DuncVern	Microsoft Excel Worksheet Functions	1	1st Apr 2004 05:16 PM