Office Settings & Configuration

Why Ctrl+Shift+Enter Doesn't Insert a Page Break in Excel & How to Fix It

Bushra Parveen Oct 15, 2026 868 views

Question details

The user is attempting to use the Ctrl+Shift+Enter keyboard shortcut to insert a page break in Excel, but the shortcut does not work for this action.

Why Ctrl+Shift+Enter Does Not Insert an Excel Page Break

Product: Microsoft Excel
Device & OS: not provided
Scenario: Formatting a spreadsheet for printing and trying to quickly split pages using a keyboard shortcut.
Observed behavior: Pressing Ctrl+Shift+Enter does not insert a page break. Instead, it either does nothing or creates an array formula, as Excel does not have a built-in shortcut for inserting page breaks.

Before you start

Ensure you have selected the exact row or column where you want the new page to begin before attempting to insert a page break. Remember that Excel shortcut behaviors differ significantly from Microsoft Word.

Solution 1Recommended

Insert a Page Break Manually via the Page Layout Ribbon

Since Excel lacks a native keyboard shortcut for page breaks, the most reliable method is using the ribbon menu options.

Microsoft Excel uses Ctrl+Shift+Enter for array formulas, not for page breaks. To format your print layout correctly, you will need to use the dedicated Page Layout tools.

Select the starting row or column

Click on the row number or column letter where you want the page break to appear. The break will be inserted above the selected row or to the left of the selected column.

Navigate to Page Layout

Go to the 'Page Layout' tab on the Excel ribbon at the top of your application window.

Insert the page break

Click on 'Breaks' in the Page Setup group, then select 'Insert Page Break' from the dropdown menu.

Insert a Page Break Manually via the Page Layout Ribbon

Shortcut Misconception: While Ctrl+Enter or Ctrl+Shift+Enter might insert page or section breaks in word processors like Microsoft Word, in Excel, CSE (Ctrl+Shift+Enter) is strictly used for array formulas.

Solution 2

Use the Alt Key Sequence to Insert a Page Break

If you prefer not to use your mouse, you can use Excel's Alt key sequence to navigate the ribbon quickly.

Print Formatting Made Simple

Easily Manage Page Breaks in WPS Spreadsheet

WPS Office provides an intuitive and user-friendly interface for managing page breaks and printing layouts. It is fully compatible with Microsoft Excel formats and offers a lightweight, free alternative for all your spreadsheet tasks.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open your spreadsheet workbook.
2. Select the target location: Click the row or column header where you want the new page to start.
3. Insert the page break: Go to the 'Page Layout' tab, click 'Breaks', and choose 'Insert Page Break'.

Seamlessly insert and manage page breaks for perfect print layouts100% compatible with Microsoft Excel (.xls, .xlsx) filesLightweight application that runs smoothly on all devicesFree to use with a familiar, easy-to-navigate tabbed interface

microsoft office alternative - wps office

Frequently Asked Questions

How do I remove a page break in Excel?

To remove a page break, select the row immediately below or the column immediately to the right of the existing page break. Go to the Page Layout tab, click on Breaks, and select 'Remove Page Break'.

Can I view all my page breaks before printing?

Yes, you can view your page breaks by switching to 'Page Break Preview'. Go to the View tab on the ribbon and click on 'Page Break Preview'. This will show blue lines indicating exactly where your pages will split.

Can I create a custom keyboard shortcut for inserting page breaks in Excel?

Yes, you can create a custom shortcut by recording a macro that inserts a page break. Once recorded, you can assign a specific keyboard shortcut (such as Ctrl+Shift+P) to that macro via the Developer tab.

How can I reset all page breaks in my Excel worksheet?

To remove all manual page breaks at once, go to the Page Layout tab, click on Breaks in the Page Setup group, and select 'Reset All Page Breaks'. This restores the default automatic page breaks based on your paper size and margins.

Office App Problems