Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Access101
 
Posts: n/a
Default Hide Rows - copy and paste only rows that show

Hello,

If you could tell me how to do the following it would be appreciated.
If I hide rows 2, 4, 6 in a 7 row spreadsheet, then rows 1,3,5, 7 are
showing. If I highligh these row numbers, copy, and paste, it pastes rows
1-7, not the odd rows that are showing. Any help is appreciated.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default Hide Rows - copy and paste only rows that show

We could copy only the visible rows using F5 Special

After you select the rows 1-7,
press F5 Special Check "Visible cells only" OK
then right-click to copy (and paste elsewhere)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Access101" wrote in message
...
Hello,

If you could tell me how to do the following it would be appreciated.
If I hide rows 2, 4, 6 in a 7 row spreadsheet, then rows 1,3,5, 7 are
showing. If I highligh these row numbers, copy, and paste, it pastes rows
1-7, not the odd rows that are showing. Any help is appreciate



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Access101
 
Posts: n/a
Default Hide Rows - copy and paste only rows that show

That's it. Max, thanks so much.

"Max" wrote:

We could copy only the visible rows using F5 Special

After you select the rows 1-7,
press F5 Special Check "Visible cells only" OK
then right-click to copy (and paste elsewhere)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Access101" wrote in message
...
Hello,

If you could tell me how to do the following it would be appreciated.
If I hide rows 2, 4, 6 in a 7 row spreadsheet, then rows 1,3,5, 7 are
showing. If I highligh these row numbers, copy, and paste, it pastes rows
1-7, not the odd rows that are showing. Any help is appreciate




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default Hide Rows - copy and paste only rows that show

Pleasure` ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Access101" wrote in message
...
That's it. Max, thanks so much.



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
Macro to open workbook and copy and paste values in to orig workbo Dena X Excel Worksheet Functions 1 December 16th 05 12:13 AM
copy and paste hidden rows tracykrulich Excel Worksheet Functions 1 October 13th 05 05:11 PM
Copy and paste only the rows with subtotals achidsey Excel Discussion (Misc queries) 3 August 29th 05 10:00 PM
copy / paste selective rows Kenny Kendrena via OfficeKB.com Excel Discussion (Misc queries) 5 February 7th 05 01:55 PM
How to Copy & Paste Rows? none Excel Discussion (Misc queries) 6 January 29th 05 03:37 PM


All times are GMT +1. The time now is 02:52 PM.

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"