Excel: change relative address to absolute address

weixu68 · #1 Mar 7, 2005, 12:55 PM

Hi,
In Excel spreadsheet, how to change relative address to absolute address for many cells at same time? I know how to use F4 to do the change, but it is not an option when I have to deal with the addresses in a 150 row x 50 column table.
Thanks,
Wei

Dreamboat · Mar 9, 2005, 05:58 PM

I'm getting this answer for you.
It requires a macro.



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!