Share via

F4 function in Excel doesn't apply

Anonymous
2022-03-26T21:19:58+00:00

Hi

I turn on the fn (function) button to make the little light in the corner show. Yet the fn4 button doesn't apply in excel to make a cell absolute. I dont seem to get any fn-key to respond.

Kind regards

Jessica

**Moved to Office (not a device specific issue)**

Microsoft 365 and Office | Excel | Other | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-03-27T02:21:34+00:00

    Hello Jessica,

    Welcome to Microsoft Community and appreciate your time taken for sharing detailed information. I understand that F4 function in Excel doesn't apply. I could share with you some of my thoughts on this issue.

    Some questions before proceeding. I want to ask what your version of Office looks like. Have you ever tried updating or reinstalling your Office? Are you using a MacOS computer or a Windows computer? Are you using a laptop keyboard?

    If you are using a Windows system, you couldn’t select a cell and press F4 and have it change all references to absolute. And you need to have your marker placed inside the reference in the formula before it works when you hit the shortcut.

    Feel free to post back if you need any further assistance.

    Best Regard,

    Kevin | Microsoft Community Support Specialist

    *Beware of scammers posting fake support numbers here."

    *Kindly Mark and Vote this reply if it helps, as it will be beneficial to more community members reading here.

    *If your problem is not solved, you could reply to the post again and we would continue to provide technical support for you.

    Was this answer helpful?

    0 comments