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...

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...

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...

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...

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...