how to set print area in excel for multiple pages

On the worksheet, select the cells that you want to define as the print area. Tip: To set multiple print areas, hold down the Ctrl key and click the areas you want to print. Each print area prints on its own page. On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

1. How do I apply the same print settings to all worksheets?
2. How do I set a print area range in Excel?
3. How do you set the print area and page break in Excel?
4. Can you split a worksheet into multiple pages for printing in Excel?
5. What settings can you change before printing an Excel document?
6. How do I apply the same format to all sheets in Excel?
7. How do I make Excel print on one page?
8. Where is the Page Setup in Excel?
9. How do I make row 1 print on every page?
10. Why is Insert Page Break not working?
11. What is Page Break view?
12. Why won't excel Let Me Set Print Area?

How do I apply the same print settings to all worksheets?

Replies (3) 

1. Press and hold the CTRL button of your keyboard.
2. While holding the CTRL button, click all of your worksheets.
3. When all of your worksheets are selected, release the CTRL button.
4. Go to Page Layout tab.
5. From the Page Layout tab, you can now customize your print layout.

How do I set a print area range in Excel?

How to set multiple print areas in Excel

1. Select the first range, hold down the Ctrl key and select other ranges.
2. On the Page Layout tab, in the Page Setup group, click Print Area > Set Print Area.

How do you set the print area and page break in Excel?

How to Set Print Area and Page Breaks in Excel

1. Select the cells you want to print.
2. Click the Page Layout tab.
3. Click the Print Area button.
4. Select Set Print Area. Once a print area is set, add additional print areas by selecting the additional cells, clicking the Print Area button, and selecting Add to Print Area.

Can you split a worksheet into multiple pages for printing in Excel?

When printing a huge spreadsheet, you can control how the data is split over multiple pages by inserting page breaks. Here's how it works: Click on the row or column that you want to move to a new page. On the Page Layout tab, in the Page Setup group, click Breaks > Insert Page Break.

What settings can you change before printing an Excel document?

Set page margins before printing a worksheet

• Select the worksheet or worksheets that you want to print. How to select worksheets. To select a single sheet: ...
• On the Page Layout tab, in the Page Setup group, click Margins.
• Do one of the following: To use predefined margins, click Normal, Wide, or Narrow.

How do I apply the same format to all sheets in Excel?

As a recap – here's how to format multiple sheets at the same time:

1. Ctrl + Click each sheet tab at the bottom of your worksheet (selected sheets will turn white).
2. While selected, any formatting changes you make will happen in all of the selected sheets.
3. Double-click each tab when you are done to un-select them.

How do I make Excel print on one page?

Shrink a worksheet to fit on one page

1. Click Page Layout. ...
2. Select the Page tab in the Page Setup dialog box.
3. Select Fit to under Scaling.
4. To fit your document to print on one page, choose 1 page(s) wide by 1 tall in the Fit to boxes. ...
5. Press OK at the bottom of the Page Setup dialog box.

Where is the Page Setup in Excel?

Method A:

1. Click the Page Layout tab in the Ribbon.
2. Go to the Page Setup group, and then you will find that some common used setups, such as margins, backgrounds and size are listed in this group. ...
3. Then a “Page Setup” box appears, and you can choose the settings based on your need.

How do I make row 1 print on every page?

Note:

1. Click the [Page Layout] tab > In the "Page Setup" group, click [Print Titles].
2. Under the [Sheet] tab, in the "Rows to repeat at top" field, click the spreadsheet icon.
3. Click and select the row you wish to appear at the top of every page.
4. Press the [Enter] key, then click [OK].

Why is Insert Page Break not working?

If manual page breaks that you add don't work, you may have the Fit To scaling option selected (Page Layout tab -> Page Setup group -> click Dialog Box Launcher Button image -> Page). Change the scaling to Adjust to instead. On the picture below, you can see 3 horizontal page breaks added.

What is Page Break view?

View > Page Break Preview. Shows how the range of the pages to print will be.

Why won't excel Let Me Set Print Area?

If your Excel spreadsheet isn't printing properly, clearing or setting a print area can often help. ... To do this from the Page Layout Ribbon, click the Print Area icon and select Clear Print Area. If you now want to redefine the print area, select the cells that you want to print.