S Shay A Member Oct 31, 2016 #1 Hi, If I drag a formula in a filtered sheet, will it overwrite the data in the filtered roes? TY
Chihiro Excel Ninja Oct 31, 2016 #2 It's so easy to try and test for yourself At any rate, it does not. Note that relative cell reference will skip over those rows as well.
It's so easy to try and test for yourself At any rate, it does not. Note that relative cell reference will skip over those rows as well.
S Shay A Member Nov 1, 2016 #3 Hi, Even in Office 2007 it doesn't overwrite? Maybe you have useful links for delvong deeper in this matter. I want to learn what would be the optimal method of working with sort and filter in Excel. Many thanks again
Hi, Even in Office 2007 it doesn't overwrite? Maybe you have useful links for delvong deeper in this matter. I want to learn what would be the optimal method of working with sort and filter in Excel. Many thanks again
