When I place a formula in a cell at the right end cell or at the bottom cell of a column works just fine. For example, a problem that I have to work with often is Linear Interpolation of data. To do this, follow these steps: Start Excel, and then open the workbook that you want to search. 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. before it gets to Excel. The "funky character" theory is confirmed. To work around this issue, set the filter criteria to Show All on each worksheet in your workbook before you perform the search. Moreover, we will teach you how to fix the Fn keys not working issue on your computer. The other is if, within Excel, that keystroke has been assigned to a macro. Hi Rex, I have also Excel 2013 from MS Partner Network Subscription and this still does NOT work. Control R and Control D not working correctly This just started with Excel a couple of day ago. 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".. Repeat step 2 for each sheet in the workbook. Method 1: Checking If the Function Keys are Locked. While this can be done using only native excel functions, it either requires a few helper columns, or a single fairly complicated formula. 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." 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. Go to the Windows search section and find the Control Panel. If you have any other questions regarding Fn key not working, please let us know, so that we could further assist you. The only way for me to proceed is to "end task" and reopen excel then reopen the file and proceed. So, it looks like I'm screwed with plain text searches on this daily spreadsheet which usually contains 350 or so rows. 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). One way to check the latter possibility quickly is to start Excel in safe mode. When one or both of these keys stop working, it can be quite annoying, especially for using some computer shortcuts. Please see similar report in question on answers.microsoft.com. From Start->Run enter "excel.exe /s" (without quotes, there is s pace before the slash). 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. On the Data menu, point to Filter, and then click Show All. I've been working with the new LET function in Excel, and I think it has strong potential to replace some VBA UDFs. Find the Make the keyboard easier to use variant and click on it. These keys are used to optimize the other keys on your keyboard by giving them additional functions, such as copying and pasting text. Most laptops have at least one Control (CTRL) key, and standard PCs usually have two. something CTRL F , or save something, the window pops up but when I click on the window to enter my data it disappears. Open Ease of Access Center. In most cases, the reason why you cannot use the function keys is because you have unknowingly pressed the F lock key. *And then they stop working, even if I’ve not shut down/restarted any apps or the laptop itself*. Don’t worry because we can teach you how to unlock the function keys on Windows 10. combinations, they work *in* CMD, and then they work –for a few minutes– in other Windows applications (eg: my Chrome browser). If Ctrl-d works then Then, click Apply —> OK. After that, find the Filter Keys option.