Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
copy and paste hidden rows | Excel Worksheet Functions | |||
Copy and paste only the rows with subtotals | Excel Discussion (Misc queries) | |||
copy / paste selective rows | Excel Discussion (Misc queries) | |||
How to Copy & Paste Rows? | Excel Discussion (Misc queries) |