Don’t worry because we can teach you how to unlock the function keys on Windows 10. On the Data menu, point to Filter, and then click Show All. The other is if, within Excel, that keystroke has been assigned to a macro. Moreover, we will teach you how to fix the Fn keys not working issue on your computer. combinations, they work *in* CMD, and then they work –for a few minutes– in other Windows applications (eg: my Chrome browser). Open Ease of Access Center. Find the Make the keyboard easier to use variant and click on it. While this can be done using only native excel functions, it either requires a few helper columns, or a single fairly complicated formula. One way to check the latter possibility quickly is to start Excel in safe mode. From Start->Run enter "excel.exe /s" (without quotes, there is s pace before the slash). To do this, follow these steps: Start Excel, and then open the workbook that you want to search. When one or both of these keys stop working, it can be quite annoying, especially for using some computer shortcuts. The Find now works in Excel, the problem is that's just an intermediate stage & I'm then accessing the Excel database from another program & it was that, initially, that couldn't find the value (which also, couldn't be found through CTRL+F). Hi Rex, I have also Excel 2013 from MS Partner Network Subscription and this still does NOT work. Then, click Apply —> OK. Most laptops have at least one Control (CTRL) key, and standard PCs usually have two. The text I was searching for had a plain space in it, but the contents of the cell I circled in red (in the image) has octal characters \302 \240 which, according to Unix Stack Exchange is a "non-breaking space".. Usually, there are two different types of keyboard shortcuts on your system--Windows-based, standard shortcuts, such as "Ctrl+C" and "Ctrl+X", and manufacturer-based hotkeys, such as the buttons combination to control wireless connection. something CTRL F , or save something, the window pops up but when I click on the window to enter my data it disappears. To work around this issue, set the filter criteria to Show All on each worksheet in your workbook before you perform the search. *And then they stop working, even if I’ve not shut down/restarted any apps or the laptop itself*. In most cases, the reason why you cannot use the function keys is because you have unknowingly pressed the F lock key. This occurs in Excel 2013 (15.0.4454.1503), MSO (15.0.4454.1504) 32-bit.Compared to your build number, it is not clear whether my build is newer or older, but the problem with Ctrl+Tab or Ctrl+F6 is definitely present. The super weird thing is, if I open CMDprompt as user not admin, test the ctrl-A, ctrl-C, ctrl-Z, ctrl-F, ctrl-S etc. Please see similar report in question on answers.microsoft.com. before it gets to Excel. If you have any other questions regarding Fn key not working, please let us know, so that we could further assist you. Go to the Windows search section and find the Control Panel. For example, a problem that I have to work with often is Linear Interpolation of data. So, it looks like I'm screwed with plain text searches on this daily spreadsheet which usually contains 350 or so rows. After that, find the Filter Keys option. If Ctrl-d works then Repeat step 2 for each sheet in the workbook. These keys are used to optimize the other keys on your keyboard by giving them additional functions, such as copying and pasting text. Method 1: Checking If the Function Keys are Locked. I've been working with the new LET function in Excel, and I think it has strong potential to replace some VBA UDFs. Control R and Control D not working correctly This just started with Excel a couple of day ago. The "funky character" theory is confirmed. The only way for me to proceed is to "end task" and reopen excel then reopen the file and proceed. If I leave the file and go back to working in Sage then come back to the file the same thing happens all over again." When I place a formula in a cell at the right end cell or at the bottom cell of a column works just fine.