Excel question: A1 to $A$1

Factual Questions
1

A quick Excel question:

I know how to change the reference in a cell from e.g. A1 to $A$1 (highlight and press F4); my question is, how do I change the references for several cells at once?

For example, my cells look like this:


 ______ _______ ______
|=A1   |=A2    |=A3   |
 ------ ------- ------

and I want to make them look like this:


 ______ _______ ______
|=$A$1 |=$A$2  |=$A$3 |
 ------ ------- ------

all at once. Does anyone know a way to make that change without changing each cell individually?

2

I think you’d need to use a VB script for this - a quick google brought up this page.

3

There isn’t an easy way to this completely automatically unless you can guarantee that there aren’t A’s displayed in your cells rather than just in the formulas. However there is a quick way to do it anyway. You need highlight the cells you want to do a replace on. Do a Search and Replace through the Edit menu as A the top and replace as A. Use Find All or Find Next (preferred) to locate cells that you want to make the change in. Click Replace when you find the right cells. Find Next and repeat.

4

Thanks for the link. I’d hoped there would be an easy function to do it in Excel, but if people are writing code I guess there’s no easy way.