| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy & paste only the unhidden data on a worksheet ?
I'm sure this has a simple solution....I have a large worksheet that has a
lot of hidden rows. I want to copy and paste only the unhidden rows and can't find a 'paste' function to do it. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I copy & paste only the unhidden data on a worksheet ?
Press F5. click special and select visible cells only, then copy and paste
-- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Johnson748r" wrote in message ... I'm sure this has a simple solution....I have a large worksheet that has a lot of hidden rows. I want to copy and paste only the unhidden rows and can't find a 'paste' function to do it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a graph and use the data in the new worksheet? | Charts and Charting in Excel | |||
| How to copy Chart and its data to another excel worksheet | Charts and Charting in Excel | |||
| how Excel can copy the data in a row of worksheet to other? | Excel Worksheet Functions | |||
| copy and paste only unhidden information | Excel Discussion (Misc queries) | |||
| trying to "paste special" data; why does worksheet object appear? | Excel Discussion (Misc queries) | |||
Linear Mode
