Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How do you copy "sheet1, column a" onto "sheet2" without using cut and paste?

I have tried using a basic =sheet1!A1 formula, and this almost works; however, I have to add and remove data from "sheet1, column a", and as a result, on "sheet 2", the cell only references the cell originally at A1 and changes up and down depending on where I've added columns or rows to sheet1. It won't automatically add the new data onto "sheet2' unless I re-cut and paste the column.

For example, if I add a column to the left of the data in column A on sheet1, the formula on sheet2 will automatically update to =sheet1!B1. I want the formula to still refer to the cell A1 though. How can I accomplish this?

Any help would be appreciated.

share|improve this question
up vote 2 down vote accepted

You can use the following function for a cell to keep its reference even when the target is moved:

share|improve this answer
You got it! Deleted my answer cause you were right! – Damon Aug 3 '13 at 16:53

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.