Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
filtered pasting
I'm trying to paste a row of formulas down a list, but in filtered mode.
Problem is that it's pasting into the lines that are not visible in the filter (those that are hidden). I thought that at one point in my past, I was pasting things and it respected the visibility factor of the filter (in other words, only pasting into those lines that were seen). I turned calculation to manual for ease of use (large list, pivots, etc), but I cannot imagine that has anything to do with it. Is there some other setting, or some particular way I have to do this (obviously aside from ctrl-selecting each line individually and skipping over the hidden rows, which is not an option with the number of lines I have. Thx for any help -- Boris |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
filtered pasting
You have a reply at your other post in .misc.
BorisS wrote: I'm trying to paste a row of formulas down a list, but in filtered mode. Problem is that it's pasting into the lines that are not visible in the filter (those that are hidden). I thought that at one point in my past, I was pasting things and it respected the visibility factor of the filter (in other words, only pasting into those lines that were seen). I turned calculation to manual for ease of use (large list, pivots, etc), but I cannot imagine that has anything to do with it. Is there some other setting, or some particular way I have to do this (obviously aside from ctrl-selecting each line individually and skipping over the hidden rows, which is not an option with the number of lines I have. Thx for any help -- Boris -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting into a filtered sheet | Excel Discussion (Misc queries) | |||
Pasting filtered rows | Excel Discussion (Misc queries) | |||
filtered pasting | Excel Discussion (Misc queries) | |||
Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
Pasting onto filtered cells | Excel Worksheet Functions |