Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Sarah
 
Posts: n/a
Default Can I copy data from only the visible rows in Excel?

I want to select rows from a worksheet with some rows hidden, copy, and paste
only the contents from the rows which are visible. How is this accopmplished?
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

Sarah

F5SpecialVisible cells onlyOK


Gord Dibben Excel MVP

On Sat, 8 Oct 2005 12:49:03 -0700, "Sarah"
wrote:

I want to select rows from a worksheet with some rows hidden, copy, and paste
only the contents from the rows which are visible. How is this accopmplished?


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
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 12:43 AM
Pivot Table - max rows allowed in data range dmotika Excel Discussion (Misc queries) 2 May 26th 05 05:52 PM
Removing blank rows in a worksheet Louise Excel Worksheet Functions 6 May 26th 05 02:21 PM
Pull Current Month's Data Out of List - Repost Karl Burrows Excel Discussion (Misc queries) 4 May 3rd 05 01:06 AM
Controlling odd even rows when pasting data [email protected] Excel Discussion (Misc queries) 1 February 23rd 05 07:11 PM


All times are GMT +1. The time now is 09:39 AM.

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

About Us

"It's about Microsoft Excel"