Home |
Search |
Today's Posts |
#1
|
|||
|
|||
international absulute cell reference
To make an absulute cell reference you use the dollar sign. How would you
make an absulute cell reference on a keyboard with no dollar sign? Example: russian keyboard, japanese keyboard, ect... |
#2
|
|||
|
|||
Hi
see your other post -- Regards Frank Kabel Frankfurt, Germany sadinga wrote: To make an absulute cell reference you use the dollar sign. How would you make an absulute cell reference on a keyboard with no dollar sign? Example: russian keyboard, japanese keyboard, ect... |
#3
|
|||
|
|||
Hi Frank
i can't find his other post - which ng? or alternatively, would you mind posting the answer here again. Cheers JulieD "Frank Kabel" wrote in message ... Hi see your other post -- Regards Frank Kabel Frankfurt, Germany sadinga wrote: To make an absulute cell reference you use the dollar sign. How would you make an absulute cell reference on a keyboard with no dollar sign? Example: russian keyboard, japanese keyboard, ect... |
#4
|
|||
|
|||
I don't really have a good way to test this, but I'm sure it would work.
In the formula bar, highlight the cell reference or range that you want to make absolute and click on the F4 (Function 4) button. By repeatedly clicking on the F4 key, you can toggle the various options you have for Absolute References. Thanks, Rekoj "sadinga" wrote: To make an absulute cell reference you use the dollar sign. How would you make an absulute cell reference on a keyboard with no dollar sign? Example: russian keyboard, japanese keyboard, ect... |
#5
|
|||
|
|||
Julie
Frank's answer from excel.public.misc Hi AFAIK it is always the $ sign in all language versions (not sure though about Japanese versions). Maybe ask this is the Japanese Excel newsgroup -- Regards Frank Kabel Frankfurt, Germany Gord On Thu, 23 Dec 2004 00:41:14 +0800, "JulieD" wrote: Hi Frank i can't find his other post - which ng? or alternatively, would you mind posting the answer here again. Cheers JulieD "Frank Kabel" wrote in message ... Hi see your other post -- Regards Frank Kabel Frankfurt, Germany sadinga wrote: To make an absulute cell reference you use the dollar sign. How would you make an absulute cell reference on a keyboard with no dollar sign? Example: russian keyboard, japanese keyboard, ect... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
international absulute cell reference | Excel Discussion (Misc queries) | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
name of another worksheet in cell for reference | Excel Worksheet Functions |