This is typically cell A1, but occasionally it will select another cell if there are header rows or frozen rows selected. You can navigate the provided colors with the arrow keys.Ĭtrl + Home: Moves to beginning of workbook. This shortcut works when in cell selection mode, not text edit mode (indicated by absence of blinking cursor). Ctrl + Shift + %: Apply percentage format to numbers.Ctrl + Shift + !: Apply number format with 2 decimal places. Keyboard stickers with the most important shortcuts in Microsoft Excel.Ctrl + Shift + $: Apply currency format to numbers.Alt + Shift + F1: Insert new worksheet.You can also delete rows or columns this way, but the shortcuts provided above are quicker. Ctrl + Shift + “+” + C: Inserts entire column.Ctrl + Shift + “+” + R: Inserts entire row.Ctrl + Shift + “+” + D: Shift cells down to insert cell.Ctrl + Shift + “+” + I: Shifts cells right to insert cell.The fourth letter indicates what type of border, such as: If you have rows or columns in freeze pane mode, the “F” option becomes unfreeze. (for example, to freeze 2 rows, select a cell in the third row.) NOTE: you must select a cell in the row below where you want to freeze the pane, then enter the shortcut. A small menu will open so you can select one of these:
#EXCEL KEYBOARD SHORTCUTS MAC MAC#
So I dug around and pulled together the list of ones that I commonly use: MAC EXCEL 2016. Tonight I was working on a large financial model and banging my head against the fact that all my old Excel keyboard shortcuts don’t work on the Mac. For this shortcut to work, you need to be in text editing mode (indicated by a blinking cursor). File this under the so I remember it later department. Here are the most useful shortcuts I’ve found for Excel:
Using Excel for the first time can be overwhelming, but just know that you can take it one cell at a time Whether you’re using Excel for the first time, or you’re a novice and you want to improve, keyboard shortcuts are something you’re going to want to know.
#EXCEL KEYBOARD SHORTCUTS MAC PC#
This is because one type of function can have several options, such as adding borders or freezing panes. The Excel Keyboard Shortcut Cheat Sheet for PC and Mac users.
Many Excel shortcuts are longer than those for other programs. Improve Your Spreadsheet Skills with ShortcutsĮven for those of us who don’t use Excel to its fullest potential, there are several keyboard shortcuts that will make our spreadsheet editing easier. Most of us use Excel to maintain contact lists and for accounting or budgeting purposes.Įxcel has a multitude of features that I never touch and probably wouldn’t be able to tell you what they do right away.
Note: Some shortcuts might not work for all languages or keyboards. Microsoft Excel looks overwhelming sometimes. Use keyboard shortcuts in Google Sheets to navigate, format, and use formulas. Previous articles list shortcuts for Microsoft Office, Word, and Outlook.) Email Pin on Pinterest Share on Google+ Share on LinkedIn Share on Twitter Share on Facebook