How can I force Excel not to hold the $M1:$M1234 relativity when I insert a new column? I have TONS of formulas that are written this way. Now my boss wants me to insert a column in the worksheet which is throwing off all of my results.
Also, once the results are thrown off, they return a REF in the formula that I have to manually update. Can I simply highlight the entire sheet and replace "REF!" with the correct column range.