Copying formulas without cell values shifting up,down, etc..
Is there anyway to copy cells with a function and paste them in another cell without the cell numbers changing.
ex. sum(b3:b8) if you would copy that up two cells it would change to sum(b1:b6) or move it over two cells it would change to sum(d3:d8). I need the entire cell structure to remain the same when I copy them.
Check XL's help on absolute and relative addressing
Originally Posted by cdevericks
Put a $ before the row or column you don't want changed. If you want B3 to stay B3, write $B$3. If you want B3 to change rows but not columns, write $B3. And so forth.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1