On the Mac, this doesn't seem to work in certain areas, notably Define Names, and the New Formatting Rule window when adding a conditional format that uses a formula. Pressing F2 / Ctrl+U repeatedly will cycle through modes.you'll see the mode displayed in the status bar, in the lower left corner. 'Edit' mode simply moves the cursor in the formula text. 'Point' and 'Enter' work similarly and allow you to point to a cell. Below we have created a FREE downloadable PDF cheat sheet and a full searchable list of the 333 Excel Shortcuts for both in Windows and Mac for you Download it, print it and post it to your wall so that you can get a quick reminder of the best Excel keyboard shortcuts out there. Once you are editing a cell, you can use the F2 / Ctrl+U again to toggle through available edit modes (edit, enter, point). Visit our page about Flash Fill to learn more about this great Excel tool. Download the Excel file and give it a try. Note: flash fill in Excel only works when it recognizes a pattern. If you want the cursor to move to the formula bar, see below. Select cell B1 and press CTRL + E (flash fill shortcut).
The utility of a shortcut reflects its expected frequency of use and its estimated time savings benefit. The shortcuts list can be sorted by action name, utility, or keystroke. This shortcut enters cell edit mode with the cursor at the end of the last line of text in the cell. The Shortcut Manager dialog, accessible from the Macabacus > Settings > Keyboard menu, is used to manage shortcut keystroke settings.
