-
×InformationNeed Windows 11 help?Check documents on compatibility, FAQs, upgrade information and available fixes.
Windows 11 Support Center. -
-
×InformationNeed Windows 11 help?Check documents on compatibility, FAQs, upgrade information and available fixes.
Windows 11 Support Center. -
- HP Community
- Archived Topics
- Unanswered Topics - Notebook
- Re: how can I use the 'f4' key in excel to put in the '$'?

Create an account on the HP Community to personalize your profile and ask a question
Your account also allows you to connect with HP support faster, access a personal dashboard to manage all of your devices in one place, view warranty information, case status and more.

06-25-2017 09:18 AM
Hi i had the same problem and tried everything what everyone suggested you to do here it didnt work and then i found the answer on google . So what you need to do is You need to make sure that you are in "edit mode" when it comes to using F4 with formulas. In other words, select the cell you want, hold FN and press F2 to enter edit mode, and then hold FN and press F4 whenever you want to cycle a reference through various permutations of absolute and relative notation. That works perfectly fine for me.

† The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.
Didn't find what you were looking for?
Ask the community
† The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the <a href="https://www8.hp.com/us/en/terms-of-use.html" class="udrlinesmall">Terms of Use</a> and <a href="/t5/custom/page/page-id/hp.rulespage" class="udrlinesmall"> Rules of Participation</a>.