Problem: My data is sorted by customer in column A. I want to put each customer on a different page.

Jul 28, 2013 So, instead of the ALT+Enter shortcut we need to enter CTRL+J, this is the shortcut to the line break which is character 10 in the ASCII control code. You can search for line breaks using this shortcut instead. So if we want to find and place out line breaks with a space. Select the cells you want to search.
To add spacing between lines or paragraphs of text in a cell, use a keyboard shortcut to add a new line. Double-click the cell in which you want to insert a line break. Click the location where you want to break the line. Press ALT+ENTER to insert the line break.

Strategy: The easiest way to do this is to add a subtotal by using the Data, Subtotals command. In the Subtotal dialog, you can choose to have a page break between groups. For more about subtotals, see 'Add Subtotals to a Data set' on page 298.

However, let's assume that you cannot use the automatic Subtotals feature for some reason. It helps to understand page breaks.

Type the first line and press Alt+Cmd+Enter keys. Also use Control + Option + Enter or Control + Command + Enter keys to create/add a line break in the cell. Note: These keyboard keys combination work in both Excel for Mac 2011 or later versions. If you have a question about Mac Excel line break, inform us via comment.

Excel page breaks can either be automatic or manual. If you access Print Preview and then close Print Preview, Excel will draw in the automatic page breaks.

In this particular report, it turns out that with these margins and print size, Excel would normally offer an automatic page break after row 46. After you do a Print Preview, Excel draws in a dashed line after row 46 to indicate that this is an automatic page break.

The dashed line is an automatic page break.
You can add a manual page break to any row. You position the cell pointer in column A on the first row for a new customer and then select Page Layout, Breaks, Insert Page Break. Excel will draw in a dotted line above the cell pointer to indicate that there is a page break after row 8.
Slightly longer dashes indicate a manual page break.
Here is a zoomed-in view of the different dashes used for each break. I am not sure the difference will even show up in the book or e-book.
Because you've added a manual page break after row 8, Excel will automatically calculate that it can fit rows 9 through 54 on page 2. The location for the next automatic page break is now shown at row 55 instead of row 47.
Automatic page breaks will move around. Say that you change the margins for the page, using Page Layout, Margins. Excel will now calculate that the end of the second page is at another row.
Unlike automatic page breaks, manual page break will never move.
To add the rest of the page breaks, you move the cell pointer to the next cell in column A that has a new customer and select Page Layout, Breaks, Insert Page Break. Because you have 50 of these to insert, you might want to use the keyboard shortcut: Alt+I+B or Alt+P+B+I.
Additional Details: Selecting each new customer is tedious. Microsoft provides a shortcut for finding the next cell in the current column that is different from the active cell. However, it is difficult to use this shortcut. You will have to decide if it is worth the hassle. You start with the cell pointer on a customer. Then you press Ctrl+Shift+Down Arrow to select all the cells below the current cell. You press the F5 key and then click the Special button. Finally, you select Column Differences and click OK. The cell pointer will move to the first row that contains a new customer. You can then use the Breaks, Insert Page Break command. You can repeat this whole series of events by holding down the Alt key while you type EGSM. Release the Alt key and press Enter. Hold down the Alt key while you type IB. If you have hundreds of page breaks to add, mastering this keystroke might be worth the time.
Additional Details: These steps might be easier than the above. Insert a new column A. The formula in A3 is =IF(B3=B2,1,True). Copy this formula down to all rows. Select column A. Press F5, then click Special. In the Go To Special dialog, choose Formulas. Uncheck Numbers, Text, and Errors, leaving only Logicals selected. Click OK. Do Alt+I+B to insert a break at the first customer. Press Enter to move to the next customer. Press F4 to repeat the last command (insert break). Continue pressing Enter, F4, Enter, F4 until you reach the bottom. You can then delete column A.
Additional Details: To remove a manual page break, you should put the cell pointer in the first cell under the manual page break. When the cell pointer is in this location, the Breaks dropdown offers a Remove Page Break option.
To remove all page breaks, you select all cells by using the box to the left of column A. The Breaks dropdown will now offer the option Reset All Page Breaks.
Gotcha: To insert a row page break, you must either select the entire row or have the cell pointer in column A. If you select Insert Page Break while in cell C9, Excel will insert a horizontal page break above row 9 and also a vertical page break to the left of column C. This is rarely what you want.

For more resources for Microsoft Excel

Manual line break excel 2016 mac add ins

When entering text into a cell, sometimes we’d like to insert a line break for betterformatting. A line break is like when you’re in Word and you press Enter tocreate a new line. This can also be called a carriage return. We’ll cover twoways to do this.

Line breaks in plain text
Line breaks in cell formulas

One thing is certain, you shouldn’t use two cells for creating the illusion of line breaks.

Adding a Line Break in Plain Text

This one is easy. While you’re editing the text of a cell, you can simply pressAlt+Enter (or Command+Option+Enter for Mac) to add a line break as shownbelow.

NOTE: This will automatically set Wrap Text ON for cell A1.

Let’s take a look at what happens when you turn Wrap Text OFF:

Manual Line Break Excel 2016 Mac Download

Notice that in the formula bar the break is kept there, but it is one singleline in cell A1. This is because Excel needs to format the break and Wrap Textis the way to do it. The formula bar is immune to show any formatting, but itwill show you the data you have (in this case, some text, then a line break andsome more text after). It’s just another way to show you that you have a breakin the cell, but it’s not formatted to show it that way.

Adding a Line Break in Cell Formulas

To enter a line break in a cell formula, reference the text and concatenate itwith the ampersand (or you can use the CONCATENATE() function) along with thefunction CHAR(10) to insert the break (CHAR(13) on Mac). The CHAR()function takes in an integer and will show a character based on that integer. Please seeMicrosoft’s page on the CHAR() functionfor more info. The 10 (13 for Mac) in this case refers to the character“Line Feed.”

Let’s take B1 and add a formula to combine cells A1 and A2 with a linebreak in between them. The formula to use is:

Windows:

Line Break Excel Cell

Mac:

Notice this time that Excel does not automatically turn on Wrap Text when weenter the line break as a formula. You have to manually turn it on to get theformatting you want.