# \$A\$1 for all

#### lezawang

##### Well-known Member
Hi

I know what \$A\$1, \$A1, A\$1 mean. But what I found out that using \$A\$1 will cover both \$A1 or A\$1.
So why bother learning when I need to use \$A1 or A\$1 when \$A\$1 will take care of both?

Thanks

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

#### mumps

##### Well-known Member
I'm not sure what you mean when you say:
will take care of both
The \$ is used to fix the column or row. If you use \$A1 in a formula and then copy that formula across row 1, the A will not change. If you use A\$1 in a formula and then copy that formula across row 1, the A will change to match the column. If you use \$A\$1 in a formula and then copy that formula across row 1 and then down a few rows, both the A and the 1 will not change. If you use A1 in a formula and then copy that formula across row 1 and then down a few rows, both the A and the 1 will change. As you can see, the \$ makes the column and the row fixed. Without the \$, the column and row will change as you copy the formula to another cell or range.

Last edited:

Last edited:

#### JLGWhiz

##### Well-known Member
So why bother learning when I need to use \$A1 or A\$1 when \$A\$1 will take care of both?
You can probably see by the responses that it does not take care of both. Depending upon how you use the A1 format as absolute or relative reference will determine how your formulas and data are manipulated, calculated and derived. The references are not the same and while you may be able to use one or the other is some cases, you cannot interchange them in all cases. I suggest that you hit the books and really learn what they mean.

Replies
3
Views
240
Replies
4
Views
254
Replies
8
Views
773
Replies
11
Views
370
Replies
3
Views
489

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,784
Messages
5,833,682
Members
430,222
Latest member
Nickkarl

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back