Hello,
Do anyone know that if excel can be copy and paste special value when some of the columns are filter? It seems that you can only do copy and paste special value when unfilter everything column.
thx
Yogi's suggestions works for me.
EDIT|Goto|Special > Select > visible_cells_only
Ctrl-c to copy
Right click location where you want to paste
Paste special | Values