I know how to use F4 to toggle between relative and absolute references in a formula when you click on the single reference. But it would be helpful if I could select a whole range of cells containing formulas and make all the references within the selected cells absolute.
Is there a way? When I search I only get info on the basics of relative vs. absolute and nothing more advanced like this.
Bookmarks