Add Fn+F4 (Absolute Cell) to Quick Access Toolbar?

kiteman112000

New Member
Joined
May 28, 2020
Messages
4
Office Version
  1. 365
Platform
  1. Windows
Fn+F4 on my laptop is an annoying and awkward reach for me, and in my work I'm constantly toggling absolute cells. I'm wondering if somewhere embedded in the upper tabs of Excel there is a button that will do this instead? Then I can add it to the Quick Access Toolbar which will be much more convenient and less time consuming than the keyboard shortcut. Thanks!
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,430
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
If you are using a Dell have a look at the Windows Mobility Center option in the link below as it might be a better option for you.

 

kiteman112000

New Member
Joined
May 28, 2020
Messages
4
Office Version
  1. 365
Platform
  1. Windows
If you are using a Dell have a look at the Windows Mobility Center option in the link below as it might be a better option for you.


HP Unfortunately.
 

kiteman112000

New Member
Joined
May 28, 2020
Messages
4
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

Bit more complicated but the same sort of Bios option on most HP computers (just be careful if playing around with the Bios settings).


Thanks, but since it's a work computer, I'm definitely not going to mess with the BIOS.

It's too bad Excel doesn't have a button for this under the Formulas tab or something. IMO it's actually shocking they missed this.
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,430
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
It's too bad Excel doesn't have a button for this under the Formulas tab or something. IMO it's actually shocking they missed this.
Not really an Excel issue, the way the function keys operate was changed by the manufacturers which is why it is still only an issue with certain makes (and why there are different ways to change it).
 
Last edited:

kiteman112000

New Member
Joined
May 28, 2020
Messages
4
Office Version
  1. 365
Platform
  1. Windows
Not really an Excel issue, the way the function keys operate was changed by the manufacturers which is why it is still only an issue with certain makes (and why there are different ways to change it).

What I mean is that to toggle absolute reference that you have to hit F4 at all. Shouldn't there be a button to press somewhere in the Excel tabs, like nearly every other adjustment you can make within a cell? i.e. changing currency, decimals, font, etc.
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,430
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
Fair point that it would be handy to have a different method on top of pressing F4 (not a good idea to use "changing currency, decimals, font, etc" as an example though as they are only formats and not on the function keys. Refresh/Calculate, Spellcheck, Help menu etc would be better examples).
 

Watch MrExcel Video

Forum statistics

Threads
1,114,116
Messages
5,546,030
Members
410,721
Latest member
adi772
Top