Copy Cell or Column without advancing formula reference?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet with formulas referring to another worksheet. I need to
copy the columns however, each time I do, the formulas advance to another
cell. Which is an incorrect reference, skewing my results.
 
You need to modify the formulas to use absolute references. Edit each of the
cell addresses in the formula and put $ (dollar signs) in front of the column
letters.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference Formula Help 1
Excel VBA 1
Excel formula to copy/paste formula needed please. 4
Keep Cell Data Blank when Copying It 5
Copy function 4
Copying formulas, relative and absolute cell references 3
Copying a range of data without adjusting formulas 16
HLOOKUP - Relative cell reference in row index number 0

Back
Top