How Cell References Automatically Adjust in Numbers

When you copy and paste a formula in Numbers it doesn't just paste an exact duplicate of the formula. Instead, it adjusts the cell references based on the locations of the original and the new location. Learn why and how it does this, and how to modify this behavior to fir your needs.

Comments: 2 Responses to “How Cell References Automatically Adjust in Numbers”

    Alan Chambers
    1 month ago

    Hi Gary, I have been using numbers for iMac for a while now and I thought I was doing OK. That was before viewing your video . In the past in numbers I could copy and paste but now I am using headers and footers copy and paste will not work for selected figures in the footer. Is it not possible to do so?.

    1 month ago

    Alan: Not sure what you are doing. What are you copying exactly, from where exactly, and where are you pasting it? Once you paste, what is not as you expected?

Leave a New Comment Related to "How Cell References Automatically Adjust in Numbers"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)