Do you use Microsoft Excel on your Mac instead of or in addition to Apple Numbers? If so, knowing some keyboard shortcuts for Excel on Mac can save you time when performing basic tasks in your spreadsheets and workbooks. Show As Microsoft products, Excel, Word, and PowerPoint have some of the same shortcuts. But most below are specific to using Microsoft Excel and will make managing your data a breeze. Moving around your spreadsheets and workbooksMoving between cells, sheets, and screens using keyboard shortcuts can get you where you need to be with your data much faster.
Selecting cellsSave yourself and your mouse a little work with these shortcuts for selecting cells, rows, columns, and screens.
Editing cellsOnce you use the above options for selecting cells, use these shortcuts to edit them or their data.
Formatting dataLike in a word processing app like Microsoft Word, you can format data in your Excel workbook cells and these shortcuts make it simple.
Working with formulasIf you work with formulas in Excel on Mac often, these shortcuts can help you do things faster.
Wrapping it upWhile this big list of keyboard shortcuts for Excel gives you lot to work with, it’s not the end. There are plenty of other shortcuts you can use when working with spreadsheets and workbooks. Pop open the Help menu in Excel and search for “keyboard shortcuts”. Also, take a look at these keyboard shortcuts for Numbers on Mac or our complete list of shortcuts for other Mac apps. How do you move cells in Excel on a Mac?Hold down OPTION and drag the cells to another location. Note: When you drag or paste cells to a new location, if there is pre-existing data in that location, Excel will overwrite the original data.
How do you move cells in Excel using the keyboard?Move around a workbook using the keyboard. To move to the next cell, press the Arrow Keys.. To move to the next cell to the right, press TAB.. To move to the next cell to the left, press SHIFT + TAB.. To move to the edge of a data region, press CONTROL + Arrow Keys.. To move to the first cell in the row, press HOME.. How do I move cells in Excel?You can move cells in Excel by drag and dropping or using the Cut and Paste commands. Select the cells or range of cells that you want to move or copy. Point to the border of the selection. , drag the cell or range of cells to another location.
|