| View previous topic :: View next topic |
| Author |
Message |
jrlloyd
General User
Joined: 22 Jan 2007
Posts: 14
|
 Posted: Tue Aug 04, 2009 6:05 am Post subject: Can't toggle relative/absolute references |
 |
|
Every time I try to use Shift+F4 to toggle references in a formula, all that happens is that a new sheet opens.
I've looked in Tools, customise, keyboard & Shift +F4 is listed as "Relative/Absolute References" so now I'm feeling lost any help please? (I find the customize keyboard feature particularly impenetrable)
_________________
JohnL |
|
| Back to top |
|
 |
keme
Moderator
Joined: 30 Aug 2004
Posts: 2732
Location: Egersund, Norway
|
| Posted: Wed Aug 05, 2009 4:40 pm Post subject: |
|
|
If you're on an Apple laptop, you probably need to hold the Fn key down too. I don't have the mac at hand, so I can't test it right now, but there may also be some mixup with shift, option (alt) and command keys. Try out different combinations and see if you have any luck.
Edit: Just tried, and Fn+Shift+F4 works on my MacBook.
Last edited by keme on Thu Aug 06, 2009 4:04 am; edited 1 time in total |
|
| Back to top |
|
|
jrlloyd
General User
Joined: 22 Jan 2007
Posts: 14
|
| Posted: Thu Aug 06, 2009 2:22 am Post subject: |
|
|
Sorry - should have specified its Windows XP Sp3 & OO 3.1
_________________
JohnL |
|
| Back to top |
|
|
keme
Moderator
Joined: 30 Aug 2004
Posts: 2732
Location: Egersund, Norway
|
| Posted: Thu Aug 06, 2009 4:11 am Post subject: |
|
|
| jrlloyd wrote: | | Sorry - should have specified its Windows XP Sp3 & OO 3.1 |
Then I'm sorry for making the wrong assumption. I thought I'd seen you stating you used a Mac previously, and jumped to the wrong conclusion.
Another thought: The hotkey can only modify one reference at a time. If the selected cell has more than one cell/range reference, you must be in edit mode for it to work (press function key F2 to get there) and the text cursor must be at/within the reference you want to alter. |
|
| Back to top |
|
|
|
