Get instant live expert help on I need help with excel keep cell constant

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I am creating a formula using multiple cells. I want to use the same cell c26 in each formula. How can I keep this cell constant in my formula?
Solved by I. S. in 21 mins
Is it possible to keep the values constant in a column and multiply with other columns
Solved by V. D. in 15 mins
I'm working with a column of texts of variable length and would like to eliminate the first three characters from left and keep the rest. I cannot use the RIGHT command because the number of characters I want to keep is not constant.
Solved by I. J. in 17 mins
I am trying to use one cell as a constant in a spread sheet
Solved by V. H. in 28 mins
I need to insert new rows in an sheet and keep the reference to one cell constant. For example, I type =b2 in cell a2. I always want a2 to take value from b2 even if i enter rows above b2. So when b2 becomes b3 when I insert row above b2, I want a2 to take its new value from b2 only and not from b3. How can I do this?
Solved by T. W. in 22 mins