If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copy and Paste hidden rows
I would like to copy from one worksheet that has hidden
rows, and paste to another worksheet not including the hidden rows. So only paste the data that is showing (not hidden) from the first worksheet. Is this possible? |
#2
|
|||
|
|||
Copy and Paste hidden rows
Hi
after selecting your range hit F5m click 'Special' and choose 'only visible cells' now copy and paste your data -- Regards Frank Kabel Frankfurt, Germany DuncVern wrote: I would like to copy from one worksheet that has hidden rows, and paste to another worksheet not including the hidden rows. So only paste the data that is showing (not hidden) from the first worksheet. Is this possible? |
Thread Tools | |
Display Modes | |
|
|