[Excel] : Freeze an entire range
Solved
Foreverson
Posted messages
244
Status
Membre
-
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 réponses
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.
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.
lecerf
thank you
