Change all cells to Absolute $?$

j4ymf

Well-known Member
Joined
Apr 28, 2003
Messages
594
Platform
MacOS
Hello
Is there a way where you can change all the cells to absolute references?

I want to select A1:OO100 and change all the formula to $?$ what is the short cut to do this?
im using a Mac.

Thank you
 
Last edited:

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,368
Office Version
2019, 2016, 2013
Platform
Windows
not sure about Mac, F4 cycles it, or maybe ASAP utilities is available for Mac
 

Watch MrExcel Video

Forum statistics

Threads
1,102,470
Messages
5,487,076
Members
407,575
Latest member
Stephen66

This Week's Hot Topics

Top