[Excel] : Freeze an entire range
Solved
Foreverson
Posted messages
244
Status
Member
-
lecerf -
lecerf -
Hello, as the title indicates, I would like to know how to automatically fix an entire range of data?
Basically, you need to add "$" everywhere it's possible...
How to automatically add dollar signs to the range B4:G33?
Thank you for your help.
Basically, you need to add "$" everywhere it's possible...
How to automatically add dollar signs to the range B4:G33?
Thank you for your help.
4 answers
-
Hello
All of this also depends on the formula placed in each cell of the range, as you can use the "replace" function
for example to transform =B1*C1 into $B$1*$C$1, you can:
1°) Replace B with $B$
2°) Replace C with $C$
Just in case, for your information, you can move a range of cells without modifying the formulas by:
selecting the range
holding down the left click on the top edge to make the cross appear
dragging to the new location
Best regards
--
Truth is not possessed, it is only sought.
