• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 500
  • Last Modified:

How do I copy formula to the next column and have it auto change one parameter?

I have the following formula:


...I can copy it to the next column and it of course changes the C and E to D and F, but I really only want it to change the second set of numbers and leave the C as is.

How do I do this?
Kevin Smith
Kevin Smith
1 Solution
zorvek (Kevin Jones)ConsultantCommented:
Use absolute references:


Kevin SmithAuthor Commented:
Perfect, thanks!
For info - the $ fixes the parameter which it prefixes eg

$A1 - fixes just the column reference
A$1 - fixes just the row reference
$A$1 - fixes both row and column

Tip: Put the cursor on the cell reference in the formula bar and press [F4] to cycle through the options.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now