constant formulas

[Johnm0911]

i have a formula for a cell on a spreadsheet that copies a cell from another sheet. i want to copy that formula to more cells in the same column on the same sheet. 

Example:

Invoice

Fleet Overview

Recap ='Fleet Overview'!s53 is current formula in cell C3 on this sheet. i want to copy this formula to multiple cells in column C on this sheet but all have got to be the value that is in S53 on sheet 

[#2 · Accepted solution]

@Johnm0911 

Use ='Fleet Overview'!$S$53

The dollar sign make the reference absolute, so that the column and row references do not change when you copy the formula down and/or across.

[#3]

@Johnm0911 

Change the formula to

='Fleet Overview'!$S$53

The $ signs "fix" the column letter and row number.

[#4]

thank you.