While this combines the text, this is not really the format that I want. So you can use the good old CONCATENATE function (or the ampersand & character) to combine cells and get line break in between.Īgain, considering you have the dataset as shown below that you want to combine and get a line break in between each cell:įor example, if I combine using the text in these cells using an ampersand (&), I would get something as shown below: If you’re using Excel 2016 or prior versions, you won’t have the TEXTJOIN formula available. Note: If you are using MAC, use CHAR(13) instead of CHAR(10). Once you click on the Wrap Text option, you will see the resulting data as shown below (with each address element in a new line): 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. To make sure you have all the line breaks in between each part, make sure the wrap text feature is enabled. 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). 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. Start a New Line in Excel Cell Using Formula
Hold the ALT key and press the Enter key for Windows (for Mac – hold the Control and Option keys and hit the Enter key).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).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 Start a New Line in Excel Cell Using Formula.Start a New Line in Excel Cell – Keyboard Shortcut.Then press fn+F11 to bring all your windows back to their original positions.īy the way, you can plug a Windows USB keyboard into a Mac, although not all of the task keys function the way they do on a PC.
But, you can make Mac’s delete key function like the Windows delete key if you hold the fn key while pressing it - deleting characters to the right. Another favorite keyboard shortcut on Mac OS is fn + F11 which will temporarily hide your windows to expose your desktop, allowing you to easily select files without going to the finder or minimizing all of your windows. Speaking of the Mac keyboard, the delete key is equivalent to the backspace key on a Windows computer - it deletes characters to the left of the cursor. Hold shift while doing this to select the characters between cursor positions.
But, if you hold down the fn (or control) key, you can use the left and right arrow keys as home and end keys respectively. These guys make it a breeze to select a single line of text or jump to the end of the line to keep writing after an edit.īecause Apple market share is at an all time high, I’m sure a lot of people are going to notice the absence of these keys when they switch. Unless you’ve got the full-size apple keyboard, the “home” and “end” keys are absent on your desktop or macbook keyboard. For example, I really like the home and end keys on Windows keyboards. I use both Mac and Windows computers and I appreciate some attributes of each.