| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do you paste data when autofilter is on?
-- JacB |
|
#2
|
|||
|
|||
|
Hi
- select the data range - hit F5, click 'Special' and choose 'Visible cells only' - now copy+paste your data -- Regards Frank Kabel Frankfurt, Germany "Jac" schrieb im Newsbeitrag ... -- JacB |
|
#3
|
|||
|
|||
|
If you're trying to paste a bunch of rows into the visible cells (discontiguous
rows), excel doesn't support this directly. To make life easier, you could sort your data and paste in that contiguous range. Or you could use a macro that copies row by row and pastes into visible rows (row by row). http://groups.google.com/groups?thre...apeXSPAM.c om If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Jac wrote: -- JacB -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Limiting Data Obatined By A Graph From A Spread Sheed | Charts and Charting in Excel | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Linear Mode
