Ctrl+F will find numbers in Column A, yet not in Column B. RandiO, In EXCEL, is it possible to change the default FIND option from WITHIN SHEET to WITHIN WORKBOOK ? Freeware to edit the context menu drop down (right click) in Win 10, Multiple Processes going on with all Browsers, On the left-hand side of your dialog box, click, On the lower left-hand corner of your dialog box, click. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. Click OK to close the word Options dialog box. When you click that key combination it no longer opens up the Find & Replace dialog box. Viewed 12k times 2. I was just putting up with this new behavior in Word2010. Dan, @Dan: Yes, but I do not know to without expert help. Thread starter yankee428; Start date May 11, 2004; Y. yankee428 Active Member. This is because by default the Find looks IN the formula and not the result in the cell. If you would like to help keep Daves Computer Tips FREE click the PayPal logo below. This could be for a number of reasons but in this case we are assuming that you know it is there and can see it yourself. What can be done to ensure Ctrl+F works in Column B? Searching for a string in Excel (via ctrl-F) comes up with "We could't find what your looking for". In my line of work, we implement our company's private equity accounting software for private equity fund managers who want to do accounting in house on a proper Accounting Information System. The only way for me to proceed is to "end task" and reopen excel then reopen the file and proceed. That is, if you hit the F1 through F12 keys, the media keys (mute, lower volume, increase volume, etc.) For more Microsoft Office tips visit. I'm guessing you have either Formulas or … What happens since version 2010 is that a pane will appear on the left-hand side of your screen that will allow you to search. Welcome aboard and thank you for subscribing! Disable Scroll Lock. Click on the Options button on the Find dialog (if you don't see the options) Then change the Look in: option to Values. One of the common reasons why the arrow keys don’t work in Excel is because … We do not spam and we will not share your address. Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. So in the formula there is nothing that says AuditExcel, but rather “Audit”,”Excel”. Use The On-Screen Keyboard To Turn Off Scroll Lock . In my opinion, this is Excel's biggest power feature that all users should learn. Click CTRL + F. Just under the Current Keys box, Word will inform you that this shortcut key is current assigned to the NavPaneSearch command. May 11, 2004 #1 Anyone come accross a manual recalc where F9, Shift+F9 work, but ctrl+alt+F9 doesn't???? You are more persistent than I am, Carol Bratt, Excel will not let me copy and paste a formula and will only paste the value into to workbook. You can make it happen! are triggered, rather than the standard F1-F12 commands. However when I highlight the bottom cells along the columns and hit "Control R" the results in the columns are the same as the first column. CTRL+F doesn't work. Now then, when you click CTRL + F, you will see the familiar ‘Find’ tab of the ‘Find and Replace’ dialog box that you were used to. Active 6 months ago. working on cash flow projection report and my formula is not working example =f-c+e it is not calculating Solved by Z. E. in 15 mins Hello, apparently there is a link on my workbook but I'm not able to find it. It's free, convenient, and delivered right to your inbox! When I place a formula in a cell at the right end cell or at the bottom cell of a column works just fine. Simply press the scroll lock button on your keyboard and the lock will be disabled. I am running XP on XP . The below screenshot tells the whole story. You will receive a welcome email shortly and are required to click the confirmation link contained in the email to confirm your subscription. You should find that the scroll lock light is no longer on on your keyboard. Click Close to close the Customize Keyboard dialog box. Note:If your media keys aren’t working, you have the opposite problem: your F1 through F12 keys have been set as the dominant commands. Ask Question Asked 2 years, 4 months ago. This would be convenient for me since I typically want to always find a string within the entire workbook rather than an individual sheet, and I’m weary of having to make this change each time I open a spreadsheet.. I am trying to do a very simple copy and paste of a simple formula in Excel 2007 and nothing seems to be working.