Simple question on formating CELL

%3CLINGO-SUB%20id%3D%22lingo-sub-1983964%22%20slang%3D%22en-US%22%3ESimple%20question%20on%20formating%20CELL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1983964%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20CAN%20NOT%20REMEMEBR%20HOW%20TO%20DO%20THIS.%3C%2FP%3E%3CP%3Ei%20NEED%20TO%20REPEAT%20REFERENCE%20TO%20ONE%20OR%202%20PARTICULAR%20CELLS%20AS%20I%20GO%20DOWN%20THE%20COLUMN.%3C%2FP%3E%3CP%3EWHAT%20IS%20THE%20THE%20FORMAT%20TRICK%20TO%20DO%20THIS%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eie%20-%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%3Da1%2Bc5%2Be7%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%3Da2%2Bc5%2Be7%3C%2FP%3E%3CP%3Eim%20REPEATING%20THE%20REFERENCE%20TO%20CELL%20C5%20AND%20E7.%20ROW%20BY%20ROW.%20SO%20WHAT%20THE%20FORMAT%20TRICK%3F%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1983964%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1984233%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20question%20on%20formating%20CELL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1984233%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F900719%22%20target%3D%22_blank%22%3E%40Wheelman666%3C%2FA%3E%26nbsp%3BNot%20formatting%2C%20I%20guess.%20Absolute%20references%2C%20perhaps.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%20%3DA1%2BC%245%2BE%247%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3ECopy%20this%20formula%20down%20and%20A1%20becomes%20A2%2C%20A3%20etc.%2C%20but%20C5%20and%20E7%20remain%20%22frozen%22%20due%20to%20adding%20dollar%20sign%20to%20the%20row%20reference.%3C%2FP%3E%3CP%3EAdding%20a%20dollar%20sign%20before%20the%20column%20reference%20will%20freeze%20the%20column.%20This%20would%20be%20needed%20if%20you%20want%20to%20copy%20the%20formula%20horizontally%20so%20that%20A1%20becomes%20B2%2C%20B3%20etc.%3C%2FP%3E%3CP%3EHaving%20the%20dollar%20sign%20in%20both%20places%2C%20will%20freeze%20the%20reference%20in%20both%20directions.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

i CAN NOT REMEMEBR HOW TO DO THIS.

i NEED TO REPEAT REFERENCE TO ONE OR 2 PARTICULAR CELLS AS I GO DOWN THE COLUMN.

WHAT IS THE THE FORMAT TRICK TO DO THIS?

 

ie -

        =a1+c5+e7

        =a2+c5+e7

im REPEATING THE REFERENCE TO CELL C5 AND E7. ROW BY ROW. SO WHAT THE FORMAT TRICK???

1 Reply

@Wheelman666 Not formatting, I guess. Absolute references, perhaps.

 =A1+C$5+E$7

Copy this formula down and A1 becomes A2, A3 etc., but C5 and E7 remain "frozen" due to adding dollar sign to the row reference.

Adding a dollar sign before the column reference will freeze the column. This would be needed if you want to copy the formula horizontally so that A1 becomes B2, B3 etc.

Having the dollar sign in both places, will freeze the reference in both directions.