constant formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-2688549%22%20slang%3D%22en-US%22%3Econstant%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2688549%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20have%20a%20formula%20for%20a%20cell%20on%20a%20spreadsheet%20that%20copies%20a%20cell%20from%20another%20sheet.%20i%20want%20to%20copy%20that%20formula%20to%20more%20cells%20in%20the%20same%20column%20on%20the%20same%20sheet.%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%3C%2FP%3E%3CP%3EInvoice%3C%2FP%3E%3CP%3EFleet%20Overview%3C%2FP%3E%3CP%3ERecap%20%3D'Fleet%20Overview'!s53%20is%20current%20formula%20in%20cell%20C3%20on%20this%20sheet.%20i%20want%20to%20copy%20this%20formula%20to%20multiple%20cells%20in%20column%20C%20on%20this%20sheet%20but%20all%20have%20got%20to%20be%20the%20value%20that%20is%20in%20S53%20on%20sheet%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2688549%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2688639%22%20slang%3D%22en-US%22%3ERe%3A%20constant%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2688639%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1138563%22%20target%3D%22_blank%22%3E%40Johnm0911%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%26nbsp%3B%3CSTRONG%3E%3D'Fleet%20Overview'!%24S%2453%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EThe%20dollar%20sign%20make%20the%20reference%20absolute%2C%20so%20that%20the%20column%20and%20row%20references%20do%20not%20change%20when%20you%20copy%20the%20formula%20down%20and%2For%20across.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2688655%22%20slang%3D%22en-US%22%3ERe%3A%20constant%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2688655%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1138563%22%20target%3D%22_blank%22%3E%40Johnm0911%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EChange%20the%20formula%20to%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3D'Fleet%20Overview'!%24S%2453%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20%24%20signs%20%22fix%22%20the%20column%20letter%20and%20row%20number.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 

 

3 Replies

@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.

@Johnm0911 

Change the formula to

 

='Fleet Overview'!$S$53

 

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

thank you.