Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy & paste special under a filter
Why sometimes paste special under a filter only paste to the filtered rows,
but sometimes are pasted to all the unfiltered rows? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy & paste special under a filter
I bet it only ever pastes to the contiguous cells. But maybe you got lucky in
that all the visible cells were contiguous. Holly wrote: Why sometimes paste special under a filter only paste to the filtered rows, but sometimes are pasted to all the unfiltered rows? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy & paste special under a filter
What do you mean by contiguous cells? Are the contiguous cells from the
filter or...? "Dave Peterson" wrote: I bet it only ever pastes to the contiguous cells. But maybe you got lucky in that all the visible cells were contiguous. Holly wrote: Why sometimes paste special under a filter only paste to the filtered rows, but sometimes are pasted to all the unfiltered rows? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy & paste special under a filter
Contiguous means touching.
So if you filtered and saw that rows 8-15 are visible and pasted 4 cells starting in row 8, it would be pasted in 8, 9, 10, 11 (all visible). If you filtered and saw rows 8, 10, 12, 14, ... and copy|Pasted 4 rows starting in row 8, you'd still paste to rows 8, 9, 10, 11 (some visible and some not visible). Holly wrote: What do you mean by contiguous cells? Are the contiguous cells from the filter or...? "Dave Peterson" wrote: I bet it only ever pastes to the contiguous cells. But maybe you got lucky in that all the visible cells were contiguous. Holly wrote: Why sometimes paste special under a filter only paste to the filtered rows, but sometimes are pasted to all the unfiltered rows? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy formulas to a new workbook? Paste Special is different | Excel Worksheet Functions | |||
Copy and Paste Special (Formulas) pastes cell value if numeric | Excel Discussion (Misc queries) | |||
can you copy and paste row height formatting in excel | Excel Discussion (Misc queries) | |||
Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) |