mac microsoft excel keyboard shortcuts cheat sheet

Like this one client, who didn’t believe me when I said I can actually move the tab using just the keyboard. It’s funny how many times I amaze people with the simplest adjustment to their workflow. In this video, I will teach you how to insert a blank sheet, and how to move and rename tabs (worksheets), using Excel shortcuts for both PC and Mac.ĭownload FREE Hands-On Exercises Full Video Transcript: Start a New Line in Excel Cell Using Formula.Start a New Line in Excel Cell – Keyboard Shortcut.For all you visual people out there, this one takes a little getting used to, but once you learn it you can save a bunch of time AND feel like a badass. Here are the steps to start a new line in Excel Cell using the shortcut ALT + ENTER: To start a new line in an Excel cell, you can use the following keyboard shortcut: Start a New Line in Excel Cell – Keyboard Shortcut

Place the cursor where you want to insert the line break.Double click on the cell where you want to insert the line break (or press F2 key to get into the edit mode).

Hold the ALT key and press the Enter key for Windows (for Mac – hold the Control and Option keys and hit the Enter key).

Start a New Line in Excel Cell Using Formula If you’re using Excel 2019 or Office 365 (Windows or Mac), you can use the TEXTJOIN function to combine cells and insert a line break in the resulting data.įor example, suppose we have a dataset as shown below and you want to combine these cells to get the name and the address in the same cell (with each part in a separate line): While keyboard shortcut is fine when you are manually entering data and need a few line breaks.īut in case you need to combine cells and get a line break while combining these cells, you can use a formula to do this.

The following formula will do this: =TEXTJOIN(CHAR(10),TRUE,A2:E2)Īt first, you may see the result as one single line that combines all the address parts (as shown below). To make sure you have all the line breaks in between each part, make sure the wrap text feature is enabled. To enable Wrap text, select the cells with the results, click on the Home tab, and within the alignment group, click on the ‘Wrap Text’ option.

Mac microsoft excel keyboard shortcuts cheat sheet