When I paste a link from one sheet to another, it shows up as =MAIN!$B$211. Then when I drag this across a range of cells, it stays the same. I want it to change to =MAIN!$B$211, =MAIN!$C$211, =MAIN!$D$211, etc. I know I can get rid of the dollar signs before dragging and that will do it but I want to put the $ back in. Is there a way to toggle the $ on and off for a cell or a range of cells? Thanks.
Bookmarks