In Excel 2007, the first row is filtered - Column A: # and Column B: information.
A ranges from 1 - 10. I filter on 4, and copy from Sheet 1, and past special values and format in Sheet 2. However, all values paste rather than just filetered 4.
This problem never happened in Excel 2003. Can you please advise?