Move to the edge of the current data regionĪctivate the arrow keys to extend a selection Let’s have a look at our favorite default shortcuts that will improve your productivity when using Excel on a Mac! If you wish to use an existing OSX shortcut then you must disable that first under the system preferences > hardware > keyboard > keyboard shortcuts tab.
Unfortunately, Excel for Mac works slightly differently than Excel for Windows.Īs of Excel 2008 you can customize your shortcuts under the tools menu > customize keyboard. Shortcuts are an inseparable part of building financial models with speed and style – they make us fast, efficient, and more precise in Excel.
Unfortunately there are too many details like this missing.Whether you are just starting business school with a new Mac or a longtime Apple user, it is essential you know your Mac shortcuts from your Windows ones. If Numbers could be a Mac-native Excel replacement for me, I wouldn't have to run Windows at all (Woohoo!). Excel 2008 for Mac is not an option because it is horrendously slow comparatively even though it doesn't have to run through a virtual machine. I work with spreadsheets from several hundred to 70,000 lines long, and currently use VMWare Fusion to run Windows Excel 2007. Menu icon A vertical stack of three evenly spaced horizontal lines. I'm going to send this post to Apple as feedback as well. Keyboard shortcuts for text formatting involve holding down two or three keys at a time to alter the appearance of text. These shortcuts, as well as their Mac equivalents (CMD instead of CTRL), do nothing in Numbers 09. Much more efficient than using the mouse for selecting long lists of data, or deleting large areas of empty cells This is incredibly useful for moving around large spreadsheets.ĬTRL-SHIFT-UP, CTRL-SHIFT-DOWN, CTRL-SHIFT-LEFT, CTRL-SHIFT-RIGHT - These do the same thing, but also select all the cells along the way. Or if a blank cell is selected, they move the view to the closest data filled cell in the indicated direction. For more information, see 'Web-based editor.' Command+B (Mac) or Ctrl+B (Windows/Linux) Inserts Markdown formatting for bolding text: Command+I (Mac) or Ctrl+I (Windows/Linux) Inserts Markdown formatting for italicizing text: Command+K (Mac) or Ctrl+K. I use the following shortcuts all the time in Excel:ĬTRL-UP, CTRL-DOWN, CTRL-LEFT, CTRL-RIGHT - These move the view to the beginning end, left, right of a block of data. Opens a repository or pull request in the web-based editor. Not as easy as Control-Shift-Down but better than "mousing to the middle". Once this is set up it is easy to repeat for other columns just leave the reorganize pane open.
When done, uncheck the "show rows that match the following" box in the reorganize pane. Back on the table, you can now click on the top cell, quickly scroll to the bottom, and shift-click the bottom cell. Now your table will show only the rows with non-blank cells in that column. In the second part of the pane that pops up is "show rows that match the following". I am assuming you are selecting all, or at least from somewhere near the top all the way to the bottom.Ĭlick "reorganize" on the menu bar. And, I don't know if you are trying to select all of the non-blank cells in the column or going down to row 10000 and selecting from there to the bottom. I'm not sure what you are going to do after you select those cells so this idea might not work for you.
If there were, Excel's Control-Shift-Down wouldn't work either. For example if you just applied a border and red fill to one cell, you can use this shortcut to apply the same formatting to one or more selected cells. Shortcut keys improve your work efficiency and most of them are easy to remember. F4 Mac shortcut Y This shortcut will repeat the last action again, when available. I am assuming there are no gaps in the data in a column. We summarized useful shortcut keys in a list by purpose.