SOLVED

Autofill

%3CLINGO-SUB%20id%3D%22lingo-sub-1388461%22%20slang%3D%22en-US%22%3EAutofill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1388461%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20apply%20autofill%20to%20produce%20the%20following%2C%20for%20example%3A%3C%2FP%3E%3CP%3E%3D(column%20A%2Bcolumn%20B)*cell%20C1%3C%2FP%3E%3CP%3EThe%20result%20I%20am%20trying%20to%20achieve%20is%20autofilling%20the%20columns%2C%20but%20keeping%20the%20cell%20fixed%2C%20e.g.%3A%3C%2FP%3E%3CP%3E%3D(A1%2BB1)*C1%3C%2FP%3E%3CP%3E%3D(A2%2BB2)*C1%3C%2FP%3E%3CP%3E%3D(A3%2BB3)*C1%3C%2FP%3E%3CP%3Eetc.%3C%2FP%3E%3CP%3EWhat%20I%20get%20using%20autofill%20is%3A%3C%2FP%3E%3CP%3E%3D(A1%2BB1)*C1%3C%2FP%3E%3CP%3E%3D(A2%2BB2)*C2%3C%2FP%3E%3CP%3E%3D(A3%2BB3)*C3%3C%2FP%3E%3CP%3Eetc.%3C%2FP%3E%3CP%3EI%20then%20have%20to%20go%20through%20manually%20amending%20the%20C%20cell%20values%20to%20C1.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%20greatly%20received.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1388461%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1388478%22%20slang%3D%22en-US%22%3ERe%3A%20Autofill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1388478%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F667374%22%20target%3D%22_blank%22%3E%40pphardwicke%3C%2FA%3E%26nbsp%3BIn%20stead%20of%20entering%20C1%2C%20enter%20%24C%241.%20This%20fixes%20both%20the%20column%20and%20the%20row.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1388493%22%20slang%3D%22en-US%22%3ERe%3A%20Autofill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1388493%22%20slang%3D%22en-US%22%3EDear%20Riny%2C%3CBR%20%2F%3E%3CBR%20%2F%3EBrilliant!%3CBR%20%2F%3E%3CBR%20%2F%3EMany%20thanks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1388508%22%20slang%3D%22en-US%22%3ERe%3A%20Autofill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1388508%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F667374%22%20target%3D%22_blank%22%3E%40pphardwicke%3C%2FA%3E%26nbsp%3BMost%20welcome.%20I%20guess%20you%20can%20predict%20what%20happens%20when%20you%20remove%20either%20of%20the%20%24%20signs.%20And%2C%20as%20a%20fellow%20Mac%20user%2C%20just%20one%20more%20tip.%20Select%20to%20reference%20in%20the%20the%20formula%20bar%20that%20needs%20to%20be%20made%20(partially)%20absolute%2C%20and%20then%20press%20cmd-t.%20C1%20changes%20to%20%24C%241.%20Press%26nbsp%3Bcmd-t%20again%20and%20it%20becomes%26nbsp%3BC%241%2C%20again%20and%20it%20becomes%26nbsp%3B%24C1%2C%20again%20and%20it%20goes%20back%20to%20C1.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1388570%22%20slang%3D%22en-US%22%3ERe%3A%20Autofill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1388570%22%20slang%3D%22en-US%22%3E...even%20better!%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello,

 

I am trying to apply autofill to produce the following, for example:

=(column A+column B)*cell C1

The result I am trying to achieve is autofilling the columns, but keeping the cell fixed, e.g.:

=(A1+B1)*C1

=(A2+B2)*C1

=(A3+B3)*C1

etc.

What I get using autofill is:

=(A1+B1)*C1

=(A2+B2)*C2

=(A3+B3)*C3

etc.

I then have to go through manually amending the C cell values to C1.

 

Any suggestions greatly received.

 

Many thanks

4 Replies
Highlighted
Best Response confirmed by pphardwicke (New Contributor)
Solution

@pphardwicke In stead of entering C1, enter $C$1. This fixes both the column and the row.

Highlighted
Dear Riny,

Brilliant!

Many thanks
Highlighted

@pphardwicke Most welcome. I guess you can predict what happens when you remove either of the $ signs. And, as a fellow Mac user, just one more tip. Select to reference in the the formula bar that needs to be made (partially) absolute, and then press cmd-t. C1 changes to $C$1. Press cmd-t again and it becomes C$1, again and it becomes $C1, again and it goes back to C1.

Highlighted
...even better!

Thank you