Go to the active cell: Control + Delete.

Move to the previous sheet in the workbook: Control + Page Down or Option + Left arrow.

Move to the next sheet in the workbook: Control + Page Down or Option + Right arrow.Move a screen to the left: Option + Page Up or Fn + Option + Up arrow.Move a screen to the right: Option + Page Down or Fn + Option + Down arrow.Move down a screen: Page Down or Fn + Down arrow.Move up a screen: Page Up or Fn + Up arrow.Move to the last cell used in a sheet: Control + End or Control + Fn + Right arrow.Move to the start of the sheet: Control + Home or Control + Fn + Left arrow.Move to the start of a row: Home or Fn + Left arrow.Move between cells (unlocked sheet): Tab key.Move up, down, left, or right one cell: Arrow keys.Moving between cells, sheets, and screens using keyboard shortcuts can get you where you need to be with your data much faster. Moving around your spreadsheets and workbooks But most below are specific to using Microsoft Excel and will make managing your data a breeze. and press the Wrap Text button under the Alignment group in Home tab.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.Īs Microsoft products, Excel, Word, and PowerPoint have some of the same shortcuts. If you require new lines added automatically as the text in the cell exceeds the width then you may use the Wrap Text option.įor that, you may select a cell, column etc. I just double-clicked after the word “With “ and press Alt + Enter to move the next words to the next line.įor Mac users, press the CONTROL + OPTION + RETURN. In the above demo, we have pre-written text in the cell. Then press Alt + Enter as shown in the interactive graphic below.

If you want to add a line in existing text, double click in the cell and single click in the area or character from where you want the new line added. Single click in the area/letter where you want the line break.Double click in the cell where you want to add a new line.So, follow these steps in the Excel for Mac: The short key for adding a new line in the Mac OS is: If it does not, make sure you press this button: Pro tip: As you press Alt + Enter, the Wrap Text button under the “Home” tab in the ribbon, “Alignment” group should be enabled/pressed.

How to insert column in excel on mac