Excel Page Break Character: Meaning and Print Breaks

Excel does not use a special character inside a cell to create a worksheet page break: page breaks are print-layout markers. In character-code terms, decimal 12 is the form-feed control character, and CHAR(12) can return it, but that character is not a reliable way to control where Excel prints a page.

What people mean by an Excel page break character

The phrase can refer to two different things: a character stored in text, or a boundary that divides a worksheet into printed pages. These are separate concepts. A page break in Excel belongs to the worksheet’s print layout; it is not a visible symbol that you type into a cell to force a new printed page.

The character sometimes associated with a page break is a form feed. In the traditional ASCII control-code set, form feed is decimal 12, hexadecimal 0C, and is often written as FF. Older printers and text-processing systems could use a form-feed code to signal that the next output should begin on a fresh sheet. Excel’s CHAR function can return the corresponding legacy character, but its behavior as displayed or exported text is not the same as inserting a worksheet page break.

This distinction matters when searching a workbook for a hidden character or cleaning imported data. Finding a form-feed character in a cell does not mean Excel has set a print boundary there. Conversely, a worksheet can contain a manual page break even though none of its cells contains a form-feed character.

What CHAR(12) does—and does not do

If cell A1 contains the formula, =CHAR(12), Excel returns the character associated with code 12 in its character set. That is the form-feed control character in the traditional code table. It may appear blank, render unexpectedly, or be difficult to inspect in the grid because it is a control character rather than an ordinary printable letter. The exact appearance can depend on the application or destination that reads the text.

It does not insert a new page into the worksheet’s print layout. Adding the formula to a cell will not reliably start the next printed page, repeat a heading, or make a selected range print as a separate sheet. Use Excel’s page-break commands for those jobs. If a text file from another program contains form feeds, they may be present as imported data, but their presence alone does not set Excel’s manual page-break positions.

Do not confuse form feed with a line break inside a cell. A line break changes how text is arranged within one cell; a page break determines where printed worksheet content continues on a new page. They operate at different levels and are controlled in different ways.

How worksheet page breaks work

Excel lays out a worksheet for printing and divides it into pages based on factors such as paper size, orientation, margins, scaling, printer settings, and the dimensions of the rows and columns. It creates automatic page breaks where the current print layout runs out of room. Those positions can change when you change the layout, the print area, or scaling.

You can also insert a manual break to choose where a page ends. In Excel for Microsoft 365 on Windows, select the cell below the row where a horizontal break should go and to the right of the column where a vertical break should go. Then choose Page Layout > Breaks > Insert Page Break. Excel inserts a horizontal break above the selected cell’s row and a vertical break to its left. Selecting a cell away from an edge can insert both kinds at once.

For example, to begin a new printed page above row 25, select a cell in row 25 and insert a break. To start a new page to the right of column D, select a cell in column E and insert one. These choices affect printing, not the underlying order or contents of the worksheet.

To inspect the result, choose View > Page Break Preview. In this view, Excel shows the worksheet divided into page regions. In the usual display, dashed blue lines represent automatic breaks and solid blue lines represent manual breaks. You can drag a break in this view to adjust the print division; doing so changes the page layout, not cell values.

Automatic breaks, manual breaks, and scaling

Automatic breaks are calculated from the current print setup. If a wide table spans several columns, Excel may split it across pages horizontally; if it has many rows, it may span pages vertically. A manual break is an instruction to divide the printout at a chosen point, subject to the page layout. Changing the print settings can alter how the worksheet fits around breaks, so always check the preview after making layout changes.

Scaling is a common reason a page break seems to move or disappear. Under Page Layout > Scale to Fit, settings such as fitting a sheet to one page wide can shrink the output and change the number and location of pages. Fit-to-page scaling may make manual breaks behave differently than expected because Excel is resizing the content to meet the selected page count. For a large worksheet, forcing the entire sheet onto one page can make its text too small to read; choosing one page wide while allowing multiple pages tall is often more practical.

Also check the selected paper size and orientation. A worksheet formatted for landscape paper may fit more columns per page than one formatted for portrait paper. Printer drivers can affect available paper sizes and printable areas, so a preview on one computer may not match a printout from another device exactly.

How to remove or reset page breaks

To remove an individual manual break, select the cell immediately below a horizontal break or immediately to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. In Page Break Preview, you can also drag a manual break back to the worksheet edge to remove it. Automatic breaks are calculated by Excel and cannot be deleted as if they were manual markers.

If the worksheet has several manual breaks and you want to clear them, choose Page Layout > Breaks > Reset All Page Breaks. This removes the manual breaks and lets Excel calculate the automatic ones again. It does not delete worksheet content. Before resetting, note any deliberate page divisions you may want to recreate.

If break indicators remain visible after returning to the normal grid, that does not necessarily mean the sheet is still in Page Break Preview. Excel can show page-break lines in Normal view after print settings have been used. On Windows, check File > Options > Advanced > Display options for this worksheet > Show page breaks to control those indicators. This changes whether the lines are displayed, not the worksheet’s print layout.

Line breaks inside cells are different

A cell line break puts text on another line within the same cell. It is useful for addresses, labels, and multi-line notes, but it does not begin a new printed page. On Windows, press Alt+Enter while editing a cell to insert a line break. On Mac, the shortcut is generally Control+Option+Return; keyboard behavior can vary with the Mac keyboard and Excel version.

In formulas, code 10 is commonly used for a line feed. With the text North in A1 and Region in B1, =A1&CHAR(10)&B1 returns North, a line break, and Region in the same cell. Turn on Home > Wrap Text if needed to display the lines within the cell. This example changes cell text only; it does not insert a print-page boundary. Code 13 is a carriage return and may occur in text imported from other systems, often alongside a line feed, but neither should be treated as Excel’s page-break control.

Excel desktop, Mac, and web differences

The ribbon path Page Layout > Breaks applies to desktop Excel for Microsoft 365 on Windows. Excel for Mac also provides page-break controls on the Page Layout tab, although the precise interface and keyboard shortcuts can differ by release. If you are using a Mac, use the ribbon’s Breaks menu and check the print preview rather than relying on a Windows shortcut.

Excel for the web has a more limited print-layout experience than the desktop application. If you need to insert, move, or carefully manage manual page breaks, open the workbook in desktop Excel and use Page Break Preview. A workbook may still be printable from the web, but the available layout controls can differ. In all versions, a cell containing a form-feed character and a worksheet page-break setting remain distinct.

Common problems and practical checks

A break appears in the wrong place: Review the paper size, orientation, margins, scaling, and print area before moving breaks. Each can change how much content fits on a page.
The printout splits a table across pages: Use Page Break Preview to see the split, then adjust the manual break or scaling. Repeating header rows can help readers identify columns on later pages; set them through Page Layout > Print Titles.
A line in Normal view looks like a page break: Switch to View > Page Break Preview to inspect the page regions, or turn off the Show page breaks display option. Hiding the line does not remove a break.
CHAR(12) looks blank or odd: It is a control character, not a printable page-break icon. If it came from imported data, inspect and clean the text using an appropriate data-cleaning method rather than expecting it to control printing.
The printout differs from the preview on another computer: Printer selection and driver settings can change the printable area and pagination. Recheck the preview on the computer and printer that will produce the final output.

Frequently Asked Questions

What is the page break character in Excel?
Excel worksheet page breaks are layout markers, not characters in cells. The related form-feed control character is decimal 12, which can be returned by CHAR(12), but it does not create an Excel page break.

Does CHAR(12) insert a page break when I print?
No. CHAR(12) returns a form-feed character in a cell value. Use Page Layout > Breaks > Insert Page Break to control a worksheet’s printed page division.

What is the difference between CHAR(10) and CHAR(12)?
CHAR(10) is commonly used as a line feed in cell text, while code 12 is the traditional form-feed control character. A line feed can make text wrap onto another line in a cell; neither code is the command for inserting a worksheet page break.

How can I see where Excel will split a printed worksheet?
Choose View > Page Break Preview in desktop Excel. It displays the page regions and their break lines, which you can inspect before printing.

How do I remove all manual page breaks?
Choose Page Layout > Breaks > Reset All Page Breaks. Excel clears manual breaks and recalculates automatic ones; it does not remove worksheet data.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.