How do you paste filtered data and prevent hidden cells from receiveing the data when you paste.
T Tavo Oct 15, 2007 #1 How do you paste filtered data and prevent hidden cells from receiveing the data when you paste.
D Dave Peterson Oct 15, 2007 #2 You don't. Maybe you can sort the range that's filtered by some key field and put all the cells that are going to be pasted in a contiguous area??
You don't. Maybe you can sort the range that's filtered by some key field and put all the cells that are going to be pasted in a contiguous area??
N Nikki Oct 15, 2007 #3 highlight the selection-->press F5 key-->click special-->select visible cells only copy and paste...only visible rows get pasted...
highlight the selection-->press F5 key-->click special-->select visible cells only copy and paste...only visible rows get pasted...
E Excel_Learner Oct 16, 2007 #4 filter your data. Select the data and press F5 and click on special and select visible cells only and copy the data and paste it.
filter your data. Select the data and press F5 and click on special and select visible cells only and copy the data and paste it.
