F4 function on EXCELL for MAC ???

[Paulo Guedes]

I cant find the way to do the same on the excell for mac

In excell when you make a selection if you press "F4" the selection become
with the dollar "$".


example: Before pressing F4 selection is "H4:H99"
After pressing F4 selection become $H$4:$H:$99

[William Smith [MVP]]

Post by Paulo Guedes
I cant find the way to do the same on the excell for mac
In excell when you make a selection if you press "F4" the selection become
with the dollar "$".
example: Before pressing F4 selection is "H4:H99"
After pressing F4 selection become $H$4:$H:$99

You're referring to making your references into *absolute* references. I
believe you're looking for this keyboard command:

Command + t

In the formula bar, where you may have something like:

=SUM(H4:H99)

you can select the references (highlight "H4:H99") and repeatedly hit
Command + t to cycle through the various permutations:

=SUM($H$4:$H$99)
=SUM(H$4:H$99)
=SUM($H4:$H99)
=SUM(H4:$H99)

You'll find this information under the Help menu by searching for
"Switch between relative and absolute references".

FYI, this newsgroup has been deprecated and replaced with
microsoft.public.mac.office. Be sure to post any further questions in
that group rather than this one. You'll have a lot more eyes seeing your
messages there.

Hope this helps!