I'm doing a report at work where the entire sheet is created by someone else with 0 regard of how it's going to be filled every day. In result, I have to change formulas every day when I open new columns or rows. Is there a way to lock certain cells to never change their formula ranges - for example I want it to always stay A3-H3. Instead when I open a new column between those cells, it changes to A3-I3.
Bookmarks