Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Neutron1871
 
Posts: n/a
Default Copying Rows when hiding other rows

Every time I hide rows in excel and go to copy the visible rows, the hidden
rows also get copied. How do I copy the visible rows without copying the
hidden rows?
  #2   Report Post  
Ken Wright
 
Posts: n/a
Default

Select the data and do Edit / Go To / Special / Visible cells only, then do your
copy.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Neutron1871" wrote in message
...
Every time I hide rows in excel and go to copy the visible rows, the hidden
rows also get copied. How do I copy the visible rows without copying the
hidden rows?



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004


  #3   Report Post  
Don Guillett
 
Posts: n/a
Default

manually have a look at f5 goto special visiblecells or in a macro
specialcells(xlcelltypevisible)

--
Don Guillett
SalesAid Software

"Neutron1871" wrote in message
...
Every time I hide rows in excel and go to copy the visible rows, the

hidden
rows also get copied. How do I copy the visible rows without copying the
hidden rows?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert rows based on specific value bob Excel Worksheet Functions 6 February 29th 08 08:11 PM
Adding Rows to Master Sheet Excel Newbie New Users to Excel 1 December 23rd 04 11:56 PM
Global hiding null rows PierreL Excel Discussion (Misc queries) 2 December 16th 04 10:49 AM
Hiding Rows Conditionally Mike Hogan Excel Discussion (Misc queries) 2 December 9th 04 11:05 PM
Hiding rows based on date Steve Excel Worksheet Functions 2 November 1st 04 03:30 PM


All times are GMT +1. The time now is 07:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"