This must be pretty normal for people who are using Excel every day, but it is a tip for me that mainly writing code and seldom using Excel. Since my current performance evaluation work need to prepare many calculation reports, Excel becomes a requied tool for this.

Just a simple question while using Excel, that I want to fix one cell value on another formula cell while copying the formula to another rows.

for example on above pic, I want to let A1 value 3 be fixed while I doing C3 = A3*B3*(A1) and copy C3’s formula to C4 = A4*B4*(A1) and C5 = A5*B5*(A1). if one use the normal copy cell technique, the formula will become C4 = A4*B4*(A2) instead of fixed at A1.

To fix the value A1 in C column’s formula cells, by referring to this post, only have to put cursor on the formula cell, on the target cell name (in this case, A1), and then press F4, the A1 cell name will become $A$1 to indicate it’s fixed, and then it’s done. (one can just put the $ sign to the row or column that want to be fixed while copying, like $A1 or A$1, or to fix both, $A$1).

that’s it, simple but useful trick, FYI.

Thanks for the tip–it was exactly what I was looking for–one of the first hits in Google.

Fantastic! Many Thanks for the Tip

Thanks Man. Been looking for this for a while

Excellent tip. Thanks much, been looking for a while.

Thanks – been searching for this and exactly what I needed

Thanks for the tip!! It was exactly what I needed!

Thanks a lot for this info.. This is exaclty what I need.. =D

Thanks Dear

Does anyone know how to do this with a Chromebook? I'm writing a really long formula with a lot of fixed cell references and it's very tedious to go back and type in $ for each one…

Thanx, It just slipped out of my mind

i've been looking for this tip for 3 months now. and this is the exact answer. a million thanx.

Thanks.. Please post some more tips ðŸ™‚

Thanks man, you just saved the day

Thanks, just slipped out of my mind and i got it again!

Thanks

YOU LEGEND!!! JUST SAVED ME SO MUCH TIME!!

Thank you so much, this is extremely helpful!

I want to know how to use the keyboard to press some buttoms so that I can fix the cell, but not put $ again and again before the cell name.

thanks very direct and useful

Thanks a lot….

It is really wonderful. It helped and helps me to save time. Thank you very much from my heart. Take care.

very useful and time saving . . .thanks for this trick ðŸ™‚

thanx 4 da tips, good guy

Thank you very much! A very useful tips !!!

Very useful!!!

you are the one… Great.

Thanks

you have given me which I was seeking

Cheers, that was to easy

Thank you.It is really work for me.. ðŸ™‚

Excellent approach. Really thanks for this.

($A$1)

Thanks, this was exact information what I was looking for.

Thanx For Ur Valuble Information

THank you for doing this!

Thank you that is a very usefull information because after breaking one hour in my excel help you have given me a excellent information. Have a nice day and god bless you

Thanks that's what I have looked for.

Great! THX

Champion. Really helpful. Thanks

thanks!

thanks!

Thanks quite helpful.

Great Thanks! Exactly what I am looking for.

Thank you, couldn't remember the rule to use in the formula, this post was spot on.

thanks, very helpful

Thanks, I was searching for this exact information. (The f4 tip came as a useful bonus)

thanx, u made it simple to understand and obviously to apply, looking forward

Thank you so much. This is Exactly what I needed.

Very nice tip

VERY VERY BRILLIANT TIPS YOU HAVE GIVEN . I REALLY KOVE YHIS TIPS

Thanks! Didn't think I would find a solution to this with my first search result xD

thanks

couldn't remembre how to do this. Thanks!

Ready

Thanks. Exactly what I was looking for.

thanks. it helps a lot

Thanks. Nicely Explained. Completed a long pending work.

First hit in google – Exactly what I needed. Thanks!

thank u very much