Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Using autofilter I retreive parameters(Speed) by/per certain Last Name.
I want to add/copy new data (Time, for example, as another column) to this selection. Copy/Paste/Special/Values doesnt work- fills only one upper cell. Please, help. |
#2
![]() |
|||
|
|||
![]()
You pasted into a range that was filtered?
If yes, then data|filter|show all. You'll see you pasted into cells that were hidden by the filter. If you're putting the same value into each of the visible cell, you could put it in one of the visible cells (paste into the formula bar) and drag down. agenda9533 wrote: Using autofilter I retreive parameters(Speed) by/per certain Last Name. I want to add/copy new data (Time, for example, as another column) to this selection. Copy/Paste/Special/Values doesnt work- fills only one upper cell. Please, help. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Frozen panes in Excel should stay put when using autofilter. | Excel Discussion (Misc queries) | |||
New Project, Different Problem: AutoFilter? | Excel Discussion (Misc queries) | |||
Can I AutoFilter an entire workbook? | Excel Discussion (Misc queries) | |||
Strange Results with Autofilter | Excel Discussion (Misc queries) | |||
Using autofilter, how do I enter several random postcodesinto 'co. | Excel Discussion (Misc queries) |