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!”
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