Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
dollar mark
What is the difference between A1 and $A$1
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
dollar mark
Hi
It's relative and absolute. For a full explanation press F1 and type relative, you will get the explanation you want. HTH John "zafer ozer" <zafer wrote in message ... What is the difference between A1 and $A$1 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
dollar mark
If you copy
=A1 to another cell it will adjust if you copy =$A$1 to another cell it will not adjust -- Gary''s Student - gsnu200908 "zafer ozer" wrote: What is the difference between A1 and $A$1 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
dollar mark
the dollar signs indicate an 'absolute' cell reference. - one $ for the
column and one $ for the row. If this cell is referenced elsewhere in the spreadsheet as A1 and the formula is copied, the cell reference will change. If it is absolute, ($A$1), the formula referening it can be copied anywhere and the reference to A1 stays the same. -- hope to help, cm "zafer ozer" wrote: What is the difference between A1 and $A$1 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
dollar mark
And with your cell reference in the edit mode, hit F4 to toggle through the
four reference modes available. When you have the one you want, hit Enter HTH Regards, Howard "zafer ozer" <zafer wrote in message ... What is the difference between A1 and $A$1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question Mark in a box | Excel Discussion (Misc queries) | |||
Comparing Row by Row - A-D dollar amounts to E dollar amount | Excel Worksheet Functions | |||
Foot mark aka single quote mark? | Excel Worksheet Functions | |||
How can I add active tick mark/check mark boxes in excel? | Excel Discussion (Misc queries) | |||
# mark | Excel Worksheet Functions |