- Printable Excel Shortcuts Cheat Sheet
- Shortcuts For Excel On A Mac
- Ms Excel Shortcut List
- Excel Shortcut Keys
- Excel Keyboard Shortcuts Pdf
Finally, some Excel shortcuts are just plain different on a Mac. For example, the shortcut for Edit Cell in Windows is F2, and on a Mac, it's Control + U. The shortcut to toggle absolute and relative references is F4 in Windows, while on a Mac, its Command T. For a complete list of Windows and Mac shortcuts, see our side-by-side list. Now in windows I was very much used to Alt key based shortcut functions that use to help me in navigating the ribbon specially in Excel. For example Alt+H+W use to wrap the text in the cell column of Excel on PC, Alt+H+B+A will put a border on all sides of the cell. In the same way I can use all commands of Excel without even touching my mouse.
Table of contents
Worksheets and WorkbooksViewRow and Column SelectionRibbon ControlPivot TablesOperating within a CellNavigating and Selecting CellsHelp and MenusGroup Selection General ExcelGeneral Cell ControlFormulas and FunctionsFormatting Text and NumbersDialog BoxesBordersAdvanced Selection Adding Content to CellsWorksheets and Workbooks
Within Excel you can conduct calculations on multiple worksheets and workbooks open at the same time. Each workbook acts as its own separate window on your PC or Mac, while each worksheet acts as a tab within a workbook with separate cells. This section of the Excel Guide offers all shortcuts you need to open, navigate between, and control all of these options.
Worksheets and Workbooks
Within Excel you can conduct calculations on multiple worksheets and workbooks open at the same time. Each workbook acts as its own separate window on your PC or Mac, while each worksheet acts as a tab within a workbook with separate cells. This section of the Excel Guide offers all shortcuts you need to open, navigate between, and control all of these options.
What's more, it supports more than 150 video and audio formats, which is not available in many other software's in the market. Have a look at the short guide on how to convert any type of video into MP3 on your Windows/Mac. It consists of all the essential features needed for converting any video format into MP3 file format. Our experts have tested many video converter's and they have come to a solution that iSkysoft iMedia Converter stands with one of the top converters in the market, because of its wide-array of amazing features and intuitive interface.Part 1. Download youtube to mp3 converter for mac free. Top 5 Video to MP3 Converter for Mac and Windows#1.UniConverter is the most used software in the market.
View
Row and Column Selection
Ribbon Control
Pivot Tables
Operating within a Cell
Navigating and Selecting Cells
Help and Menus
Group Selection
General Excel
Printable Excel Shortcuts Cheat Sheet
General Cell Control
Formulas and Functions
Formatting Text and Numbers
Dialog Boxes
Shortcuts For Excel On A Mac
Borders
Advanced Selection
Adding Content to Cells
Get more Reference tips and tricks
Subscribe to our email updates and get Reference tips direct to your inbox.
Time is money: It can sometimes take a while to find the right button to click on in the right menu. This is why many users resort to keyboard shortcuts. You can also significantly speed up the work process in Excel using shortcuts for frequently used functions and inputs. We introduce you to the most useful Excel keyboard shortcuts and explain how you can create your own.
Shortcuts mean that functions can be executed faster in many programs and operating systems. To use shortcuts like these, you usually have to press several keys simultaneously, although it's not necessary to press them exactly at the same time. It works if you simply press down one key, keep holding it down, then press another one. The function isn't carried out until you release all keys simultaneously.
/add-worksheets-using-excel-shortcuts-4178183_FINAL-5c93df31cb26486a85f8969af2167e7c.gif "Ms excel shortcut list")
Excel with Microsoft 365 and IONOS!
Use Excel to create spreadsheets and organize your data - included in all Microsoft 365 packages! Antivirus scan for mac.
Excel with Microsoft 365 and IONOS!
Use Excel to create spreadsheets and organize your data - included in all Microsoft 365 packages! Antivirus scan for mac.
The most useful Excel shortcuts
The most popular key combinations are probably [Ctrl] + [C], [Ctrl] + [V], and [Ctrl] + [X]. These enable you to copy, paste, and cut files in many application situations. These shortcuts also work in Excel. We won't introduce these shortcuts in this article, since they aren't specific to Excel and can be used universally.
Instead, you will learn which special Excel shortcuts you can use to speed up work in the spreadsheet program. Besides the shortcuts for Windows, we will also list Mac Excel shortcuts.
The command key on Mac systems has changed appearance several times in recent years. While the key used to be known as an Apple key due to the Apple company logo being printed on it, nowadays it's usually only marked with the abbreviation cmd (for command) or represented by the looped square ().
| Function | Description | Windows | Mac |
|---|---|---|---|
| Insert cells | Opens the dialog box for inserting cells, rows, or columns | [Ctrl] + [+] | [ctrl] + [⇧] + [=] |
| Delete cells | Opens the dialog box for deleting cells, rows, or columns | [Ctrl] + [-] | [⌘] + [-] |
| Edit cells | Enables you to edit the contents of a cell without switching to the toolbar | [F2] | [F2] |
| Copy cells | Copies the contents of a cell (dragged over with the mouse) to another cell | [Ctrl] + clicked mouse button | [alt] + clicked mouse button |
| Copy and insert cells | Copies the contents of a cell (dragged over with the mouse) into a new cell that is created between two others | [Ctrl] + [] + clicked mouse button | [alt] + [] + clicked mouse button |
| Change format | Opens the dialog box for changing the cell formatting | [Ctrl] + [1] | [⌘] + [1] |
| Fix cells | Switches between relative and absolute cell references while the formula is being edited if the cell is selected in the bar | [F4] | [⌘] + [T] |
| Insert date | Inserts the current date into a cell | [Ctrl] + [.] | [ctrl] + [,] |
| Insert time | Inserts the current time into a cell | [Ctrl] + [] + [.] | [⌘] + [,] |
| Insert table | Opens the dialog box for creating a table | [Ctrl] + [T] | [⌘] + [T] |
| Insert function | Opens the dialog box for inserting a function | [] + [F3] | [fn] + [⇧] + [F3] |
| Sum total | Calculates the sum of the cell(s) above the selected ones | [Alt] + [] + [0] | [⌘] + [⇧] + [T] |
| Fill out | Copies the content and format of the cell to the left of the selected cell | [Ctrl] + [R] / [U] | [⌘]+ [R] / [D] |
| Fill out several cells | Fills an entire cell area with the same value if this area is selected | [Ctrl] + [↵] | [⌘] + [↩] |
| Insert line break | Inserts a line break in a row | [Alt] + [↵] | [⌘] + [⇧] + [↩] |
| Insert comment | Inserts a comment box or opens an existing comment box | [] + [F2] | [⇧] + [F2] |
| Select rows | Selects the row(s) of the selected cell(s) | [] + [space bar] | [⇧] + [space bar] |
| Select columns | Selects the column(s) of the selected cell(s) | [Ctrl] + [space bar] | [ctrl] + [space bar] |
| Hide row | Hides an entire row | [Ctrl] + [8] | [⌘] + [8] |
| Show row | Makes the row visible again | [Ctrl] + [] + [8] | [⌘] + [⇧] + [8] |
| Hide column | Hides an entire column | [Ctrl] + [9] | [⌘] + [9] |
| Show column | Makes the column visible again | [Ctrl] + [] + [9] | [⌘] + [⇧] + [9] |
| Start of document | Jumps to the beginning of the data area (top left) | [Ctrl] + [Pos 1] | [ctrl] + [Pos 1][ctrl] + [fn] + [↑] |
| End of document | Jumps to the end of the data area (bottom right) | [Ctrl] + [End] | [ctrl] + [End][ctrl] + [fn] + [↓] |
| Start/end of a row | Jumps to the first/last non-empty cell in a row | [Ctrl] + [←] / [→] | [⌘] + [←] / [→] |
| Start/end of a column | Jumps to the first/last non-empty cell in a column | [Ctrl] + [↑] / [↓] | [⌘]+ [↑] / [↓] |
| Change spreadsheet | Switches to the next/previous spreadsheet | [Ctrl] + [PgUp] / [PgDn] | [ctrl] + [PgUp] / [PgDn][alt] + [←] / [→] |
| Insert spreadsheet | Adds a new sheet to the file | [] + [F11] | [fn] + [⇧] + [F11] |
| Save as | Opens the dialog box for saving the file under a specific path | [F12] | [⌘] + [⇧] + [S] |
| Save | Saves the document | [Ctrl] + [S] | [⌘] + [S] |
The given Excel shortcuts refer to a QWERTY keyboard. Other keyboard layouts may require different keys. On a Mac, Excel shortcuts are sometimes provided in two different versions, for example, if the keys mentioned aren't found on a MacBook.
Creating your own Excel shortcuts
Every user has different priorities and different challenges to overcome. This makes it impossible to offer all the Excel shortcuts to please everyone. But the good news is that Microsoft enables you to create your own shortcuts. You need macros for this, which make it possible to record and save a sequence of steps. When the macro is executed afterwards, the same steps will be performed automatically by Excel. The practical thing about it is that you can assign macro shortcuts and activate them quickly.
To create an Excel shortcut, first select the 'Record Macro' tool, then select a name for the macro and assign a shortcut to it. You should choose a combination that isn't already being used by Excel, otherwise the older combination will lose its original function. So, in addition to the default control key, you can also use the shift key and combine both with a letter. If you want, you can write a description with the new macro so that you can see straightaway what it does.
In this first mask, you decide how you want to save the macro. If you choose 'This Workbook' or 'New Workbook,' the macro and therefore also the Excel shortcut are only valid in a single folder. The best way around this is to select 'Personal Macro Workbook,' meaning the macro will be available whenever you use Excel.
Ms Excel Shortcut List
Once you've created a macro, you may need to make changes to it. The cell specifications within the function are always absolute. This means that as soon as you add another line, for example, it will no longer be taken into account by the macro. To change this, select the corresponding macro under 'View Macros' and go to 'Edit'. Microsoft Visual Basic for Applications (VBA) will open and this is where you can access the macro's source code and make changes. The function for selecting the area can be found, for example, under '.SetRange.'
Excel with Microsoft 365 and IONOS!
Excel Shortcut Keys
Use Excel to create spreadsheets and organize your data - included in all Microsoft 365 packages!
Excel Keyboard Shortcuts Pdf
Related articles