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

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