How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask NewITZone Your Own Question

NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

I am running excel 2013 pro in windows 10 on an HP Pavilion

Customer Question

I am running excel 2013 pro in windows 10 on an HP Pavilion g6. Cannot get f4 to work for absolute reference
JA: What's the make and model of your computer? And what version of Excel are you using?
Customer: HP pav g6 and excel 2013 professional
JA: Have you installed any updates recently?
Customer: Yes. In fact the software itself was installed only a couple weeks ago. I don't know if it was working previously as this is fist timeI've tried
JA: Anything else you want the Microsoft Office expert to know before I connect you?
Customer: I have already tried changing the functions in windows from action to function and back.
Submitted: 1 month ago.
Category: Microsoft Office
Expert:  Jason Jones replied 1 month ago.

I am the person that will be helping you today.

On your laptop, you must press the fN key and the F4 key at the same time. Does it work when you do that?

I will be standing by, looking forward to your response.

Thank you,

Customer: replied 1 month ago.
NO. Of course I've tried that. I've tried CTRL, ALT, Shift, you name it. F4 works for quick duplication of a number but not for absolute reference
Expert:  Jason Jones replied 1 month ago.

I didn't know what you have tried because you didn't list all that you did.

I have run out of ideas.

For this reason, I am opting out of the question and allowing another expert the chance to help.

The next expert will see all that is on this page, so there will be no need to repeat anything.

When another expert picks this up, you will be notified by email.

Thank you for your patience.

- Jason

Expert:  technicalcat replied 1 month ago.


Thanks for the question, and I will be helping you now. Please standby while i review your question. I will respond in the next few minutes.

Customer: replied 1 month ago.
No. I think I will go to someone in person locally.
Expert:  technicalcat replied 1 month ago.

Are you in EDIT (F2) mode when you are attempting the absolute reference?

Customer: replied 1 month ago.
I am placing the cursor in the formula field. I have also tried f2 to be sure
Expert:  technicalcat replied 1 month ago.

Do you want to continue working with me on this problem? I see you said you did not, then you replied to my query.

Customer: replied 1 month ago.
No. Thank you.