HomeApplicationOffice informationHow to Insert a Page Break in an Excel Worksheet

How to Insert a Page Break in an Excel Worksheet

Part 1 of 2:

Getting Excel Ready

  1. How to Insert a Page Break in an Excel Worksheet Picture 1
    Open your spreadsheet. Click 'File,' then 'Open,' and navigate to the folder that contains your spreadsheet. Double-click the file name to view it in Excel.
  2. How to Insert a Page Break in an Excel Worksheet Picture 2
    Open the Page Setup options.[1] Click the 'Page Layout' tab at the top of the screen and locate the group called 'Page Setup.' To view the options, click the small arrow at the bottom right of the Page Setup group.
  3. How to Insert a Page Break in an Excel Worksheet Picture 3
    Enable adjusted scaling. On the 'Page' tab of the Page Setup options, locate the section called 'Scaling.' Select 'Adjust to:' and change the percentage to 100%. Click 'OK' to save this setting.
  4. How to Insert a Page Break in an Excel Worksheet Picture 4
    Enter Page Break view. This view allows you to see where automatic page breaks occur (indicated by blue dotted lines). Knowing where the automatic page breaks occur will help you place your new page breaks appropriately. Click the 'View' tab and select 'Page Break Preview' from the Workbook Views group to launch this view.
Part 2 of 2:

Inserting and Managing Breaks

  1. How to Insert a Page Break in an Excel Worksheet Picture 5
    Click the row below your desired horizontal page break location.[2] For example, if you want to place a horizontal page break between rows 4 and 5, select row 5.
  2. How to Insert a Page Break in an Excel Worksheet Picture 6
    Insert the horizontal page break. Return to the 'Page Layout' tab and click the arrow beneath the 'Breaks' icon. From the options, select 'Insert Page Break.' A thick line will appear where the manual break was inserted.
  3. How to Insert a Page Break in an Excel Worksheet Picture 7
    Select the column to the right of your desired vertical line break. If you want to insert a vertical line break between columns C and D, for example, select column D.
  4. How to Insert a Page Break in an Excel Worksheet Picture 8
    Insert the vertical page break. On the 'Page Layout' tab, click the arrow beneath the 'Breaks' icon, then select 'Insert Page Break.' A thick vertical line will indicate the location of your new break.
  5. How to Insert a Page Break in an Excel Worksheet Picture 9
    Move your page break. If you decide your page break should occur at a different location than where you've originally inserted it, hold your mouse over the break until an arrow appears, then drag the arrow to another location.
  6. How to Insert a Page Break in an Excel Worksheet Picture 10
    Delete a page break. If you decide you no longer want a page break you've inserted, it's possible to delete the break.
    1. Delete a vertical break: Select the column directly to the right of your vertical page break. Click the arrow beneath the 'Breaks' icon and select 'Remove Page Break.'
    2. Delete a horizontal line break: Select the column just below the horizontal page break, then click the arrow beneath the 'Breaks' icon. Select 'Remove Page Break.'
  7. How to Insert a Page Break in an Excel Worksheet Picture 11
    Return to Normal view. If you don't want to see the page breaks while you work, click the 'View' menu at the top of the screen, then select 'Normal.' You can switch between these two views as needed.
3.8 ★ | 4 Vote
pagebreakselectclick

You should read it

May be interested

  • How to Move Columns in ExcelPhoto of How to Move Columns in Excel
    this wikihow teaches you how move a column to another location in microsoft excel for windows or macos. click the letter above the column you want to move. this selects the column.
  • How to Convert Measurements Easily in Microsoft ExcelPhoto of How to Convert Measurements Easily in Microsoft Excel
    excel's convert function ('=convert()') converts a measurement from one unit to another. to use this function, you will enter data and units into the formula: =convert(number, 'from_unit', 'to_unit'). first learn how to enter the convert...
  • How to Remove Leading or Trailing Zeros in ExcelPhoto of How to Remove Leading or Trailing Zeros in Excel
    this wikihow teaches you how to remove zeros from the beginning (leading) or end (trailing) of numbers in excel. highlight the cells with leading zeros. if you're working with numbers in a column, you can highlight the whole column by...
  • How to Run Regression Analysis in Microsoft ExcelPhoto of How to Run Regression Analysis in Microsoft Excel
    regression analysis can be very helpful for analyzing large amounts of data and making forecasts and predictions. to run regression analysis in microsoft excel, follow these instructions. if your version of excel displays the ribbon (home,...
  • How to Add Up Columns in ExcelPhoto of How to Add Up Columns in Excel
    this wikihow teaches you how to add two or more columns together in an excel document. you can use the sum command on both windows and mac versions of excel to do so. open your excel document. double-click the excel document that you want...
  • How to Search for Words in ExcelPhoto of How to Search for Words in Excel
    an excel document can be overwhelming to look through. thankfully, you can use the search function to conveniently locate a particular word, or group of words, in an excel worksheet. launch ms excel. do this by clicking on its icon in your...

Office information