Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy only the unhidden rows/colums?
Whenever I have to hide several rows/columns, I inevitably need to paste the
remaining unhidden rows/columns somewhere else. But when I highlight the unhidden data and paste, it pastes all of the hidden data as well. How do I copy and paste only the unhidden data? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy only the unhidden rows/colums?
Are you pasting within the same instance of Excel?
Select the range to copy edit|goto|special visible cells only Copy that selection and paste elsewhere. Tsae0c wrote: Whenever I have to hide several rows/columns, I inevitably need to paste the remaining unhidden rows/columns somewhere else. But when I highlight the unhidden data and paste, it pastes all of the hidden data as well. How do I copy and paste only the unhidden data? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy only the unhidden rows/colums?
For this type of function, I typically use an Advanced Filter to copy the
data that I need to a new location. For more information on Filters: http://office.microsoft.com/en-us/ex...anced%20Filter Deanna www.ThatOfficeGirl.com "Tsae0c" wrote: Whenever I have to hide several rows/columns, I inevitably need to paste the remaining unhidden rows/columns somewhere else. But when I highlight the unhidden data and paste, it pastes all of the hidden data as well. How do I copy and paste only the unhidden data? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy&paste a variable range rows and colums | Excel Discussion (Misc queries) | |||
How do I copy & paste only the unhidden data on a worksheet ? | Excel Discussion (Misc queries) | |||
sumif only for unhidden rows | Excel Worksheet Functions | |||
copy and paste only unhidden information | Excel Discussion (Misc queries) | |||
Excel- Saving only unhidden rows | Excel Discussion (Misc queries) |