Excel should allow to copy & paste the values even when there is filter that is used. This will make our work faster, as we need not un-filter the cells to copy and paste the values. Currently we can't make range of cells static by copy pasting when there is formula in those cells.