In the selected table instead of absolute references and repeated operation need to use the shortcut key F4, EXCEL work no reaction, for help

CodePudding user response:

F4 function that is not what you mean, it is in the state of editing the cursor on the address, press F4 can switch address reference mode, not for the selected cell in the formula of the reference model for change,

CodePudding user response:

If you use a laptop, you try fn + F4, there are a lot of laptop is the default function keys

CodePudding user response:

It is possible that other software produced a hotkey conflict

CodePudding user response:

reference 1/f, zara's reply:

the F4 function that is not what you mean, is in the state of editing the cursor on the address, press F4 can switch address reference mode, is not to select the formula in the cell of reference model change,

thanks, later see,

CodePudding user response:

refer to the second floor weixin_wuming response:

if you use a laptop, you try the fn + F4, there are a lot of laptop is the default function keys

Thank you, understand the behind, is a desktop,

CodePudding user response:

At the same time hold Fn + F4J can lock, now most laptops F1 to F12 key combination to Fn key used to realize the function