Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-14-2020, 04:23 PM
coffent coffent is offline Function key F4 stopped working Windows 10 Function key F4 stopped working Office 2019
Novice
Function key F4 stopped working
 
Join Date: Dec 2019
Posts: 22
coffent is on a distinguished road
Default Function key F4 stopped working

It used to be when I entered a cell reference (e.g. "=A1") and then pressed F4, it would cycle through various relative and absolute reference choices (e.g. "=$A$1", etc.). Now nothing happens when I press F4. Other function keys work. Is there some setting that inadvertently got changed?
Reply With Quote
  #2  
Old 11-14-2020, 11:25 PM
Purfleet Purfleet is offline Function key F4 stopped working Windows 10 Function key F4 stopped working Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 289
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Still works on mine - you know that you need to have the cell reference selected or be in the actual cell reference? it wont work if you are in a sheet name part of the formula
Reply With Quote
  #3  
Old 11-15-2020, 08:30 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Function key F4 stopped working Windows 7 64bit Function key F4 stopped working Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,460
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

My web browser returned lots of answers looking for "f4 key stopped working excel"
Perhaps try that, there are many different possibilities
Reply With Quote
  #4  
Old 11-15-2020, 08:32 AM
coffent coffent is offline Function key F4 stopped working Windows 10 Function key F4 stopped working Office 2019
Novice
Function key F4 stopped working
 
Join Date: Dec 2019
Posts: 22
coffent is on a distinguished road
Default

Yes, I've tried using F4 in every conceivable way - immediately after selecting the cell; later, with the reference highlighted, etc. These methods all used to work, but no longer.
Reply With Quote
  #5  
Old 11-15-2020, 09:03 AM
Logit Logit is offline Function key F4 stopped working Windows 10 Function key F4 stopped working Office 2007
Expert
 
Join Date: Jan 2017
Posts: 379
Logit will become famous soon enoughLogit will become famous soon enough
Default

Broken key board ?

Does the F4 key work in other workbooks or software ?
Reply With Quote
  #6  
Old 11-15-2020, 09:17 AM
coffent coffent is offline Function key F4 stopped working Windows 10 Function key F4 stopped working Office 2019
Novice
Function key F4 stopped working
 
Join Date: Dec 2019
Posts: 22
coffent is on a distinguished road
Default

Thanks, everyone, for your suggestions. I appreciate your help!
I thought the problem was restricted to Excel, but I was wrong. The solution turned out to be very simple. There's an "F Lock" key on my keyboard which I've never intentionally used (or even understood the use of). Pressing it again restored the standard functions of the function keys and solved the problem.
Reply With Quote
  #7  
Old 11-15-2020, 09:22 AM
Logit Logit is offline Function key F4 stopped working Windows 10 Function key F4 stopped working Office 2007
Expert
 
Join Date: Jan 2017
Posts: 379
Logit will become famous soon enoughLogit will become famous soon enough
Default

Interesting ... I've never seen an "F" lock key.

Glad you found an answer.
Reply With Quote
  #8  
Old 11-15-2020, 11:15 AM
coffent coffent is offline Function key F4 stopped working Windows 10 Function key F4 stopped working Office 2019
Novice
Function key F4 stopped working
 
Join Date: Dec 2019
Posts: 22
coffent is on a distinguished road
Default

In poking around the web for a solution, I learned that most modern keyboards don't have an F-Lock key, but rather a fn key. My (still current) Microsoft 4000 keyboard must be one of the exceptions.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel stopped working. nodsirrah Excel 9 07-01-2017 04:58 AM
Sent items box stopped working john pearson Outlook 0 11-18-2015 06:37 AM
Outlook stopped working CarolVee Outlook 0 07-21-2013 10:47 AM
Function key F4 stopped working Tab key stopped working in Word jgriffin Word 2 06-24-2009 04:05 PM
Function key F4 stopped working Excell stopped working TomC Excel 4 05-26-2006 11:40 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 07:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft