Which ribbon of excel do same action? Office 365, Excel for Windows 2010 & Excel for Mac Posts 27,156. CTRL+F and in the find what box enter = and ensure that the 'Look In' dropdown is set to Formulas and that the 'Match entire cell contents' box is un-checked and click Find next and it will find the first formula. Hallo und guten Tag zusammen, Da es in Excel eine Suchfunktion gibt die ich mit Strg+F aufrufen kann, möchte ich diese "Funktion" in leicht agbgeänderter Form nutzen. alternative to Ctrl+Shift+Enter on every cell of a large sheet . By ffinstad in forum Excel Formulas & Functions … Alternative to CTRL-SHIFT-ENTER Array Formula (follows previous post) By bubastisbastet in forum Excel General Replies: 4 Last Post: 01-05-2009, 10:59 PM. Here’s a bit of history as to why this (strange) decision was made and alternative keyboard shortcuts to do a Find in Outlook. I have created a map in Excel of my facility as part of a process flow analysis. I am using arrows (shapes) to indicate movement. About 90 per cent of computer users don't use CTRL-F to search for a word - as they don't know such a keyboard shortcut exists, a Google survey found. In this way you can scroll through all your formula. For some reason CTRL-F does a Forward instead of a Find. Betrifft: Suche STRG+F per Makro von: juergen Geschrieben am: 13.04.2011 15:44:39. I mean what is alternative method for this if keyboard F2 button doesnt work? Re: Alternative to F2+Enter code? I want a button to activate the code so the user does not have to use the CTRL + F … We want to see movements that our trucks are making, and there are lots of movement types. Hello everyone, I am new here to these forums, but this looks like a great community! The code should simply find and show the cell as the CTRL + F keys do. When I attempt to do that, the only "within" options in Find and Replace are Sheet or Workbook, not "selection" or the like? Hello all, When you press F2 you can see formula in the cell. Do whatever it is you want to do and then click 'Find next' again. All the data is on one worksheet and I want to search only in columns B and C. (SendKeys does not work. ) No trimming or any other fancy code. Microsoft Excel offers a couple of Excel Shortcut Keys with the help of a keyboard (also known as Keyboard Shortcuts) which handling its features and commands smartly to customize the Excel activity.The CTRL key is one of the important hotkeys in Excel that combines with other keys to make more than 90 Excel Ctrl Shortcuts.Broadly, the hotkeys are well known as shortcut keys. CTRL-F is probably the best and most widely used Keyboard shortcut. I was wondering if I could select a few cells in Excel, and the use Ctrl-F for find and replace within those cells only, rather than just the sheet or workbook.