| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste and hide cells
When I am copying data from one sheet to another, I don't want the data to
be pasted to the hidden cells on the sheet I'm copying on to ... ignore the hidden cells like the select visible cells command. Can Anyone help??? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
paste and hide cells
You could copy|paste one area at a time--being very careful not to use too large
of areas. Or maybe you could sort your data on the receiving end so that the visible cells would be contiguous and paste there in one fell swoop (and then re-sort and rehide what you want). JenC wrote: When I am copying data from one sheet to another, I don't want the data to be pasted to the hidden cells on the sheet I'm copying on to ... ignore the hidden cells like the select visible cells command. Can Anyone help??? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Any way to count cells contining one, or more STRIKETHROUGHS? | Excel Discussion (Misc queries) | |||
| Hide Rows - copy and paste only rows that show | Excel Worksheet Functions | |||
| Excel: copy and paste only shown not hidden cells into new sheet | Excel Discussion (Misc queries) | |||
| How can I hide a paste button that appears? | Excel Discussion (Misc queries) | |||
| How to hide #DIV/0! in cells waiting for input? | Excel Discussion (Misc queries) | |||
Linear Mode
