| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drag data vertically over hidden cells.. ignore hidden cells
hi
when copying and pasting data vertically on a filtered sheet the data is pasted on the rows that are hidden in between . how can i have it ignore the hidden cells and only paste to the visible cells thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
drag data vertically over hidden cells.. ignore hidden cells
If you want to paste a sngle value down the rows, paste into the top cell,
copy from this cell, highlight to the bottom and paste. If you are trying to past a group of cells, it won't work in a filter. I would suggest alternately using Data - Sort to put the data in the required order if at all possible. HTH "Derwood" wrote: hi when copying and pasting data vertically on a filtered sheet the data is pasted on the rows that are hidden in between . how can i have it ignore the hidden cells and only paste to the visible cells thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pasting data on hidden cells | Excel Discussion (Misc queries) | |||
| How do I paste hidden cells and keep them hidden? | Excel Discussion (Misc queries) | |||
| Linking Cells with Hidden Data | Excel Discussion (Misc queries) | |||
| how to ignore hidden cells with a countif | Excel Worksheet Functions | |||
| pasting data over hidden cells | Excel Worksheet Functions | |||
Linear Mode
