Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To paste copied data in filtered/visible cells only
Is there a way to paste copied data only in the visible/filtered cells in a
worksheet and not also in the hidden cells. as MS Excel 2007 usually does it? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
To paste copied data in filtered/visible cells only
Before pasting press F5, click on Special and choose the option 'Visible cells only' "Hamad" wrote: Is there a way to paste copied data only in the visible/filtered cells in a worksheet and not also in the hidden cells. as MS Excel 2007 usually does it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste data to a filtered column, pasting to visible cells only | Excel Discussion (Misc queries) | |||
paste data over hidden cells that are filtered | Excel Worksheet Functions | |||
countif only visible cells (filtered) | Excel Worksheet Functions | |||
Copy visible cells on Filtered data | Excel Discussion (Misc queries) | |||
Paste Data into Contiguous (Visible) Cells | New Users to Excel |