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