Each page is called a worksheet, and a collection of one or more worksheets is called a workbook (which is also sometimes called a spreadsheet file).

How do I specify pages in Excel?

Insert a page break

1. Click the worksheet that you want to print.
2. On the View tab, in the Workbook Views group, click Page Break Preview. You can also click Page Break Preview.
3. Do one of the following:
4. On the Page Layout tab, in the Page Setup group, click Breaks.
5. Click Insert Page Break.

How do you fit an Excel spreadsheet on two pages?

Follow these steps: Click the Page Layout tab on the ribbon. In the Scale to Fit group, in the Width box, select 1 page, and in the Height box, select Automatic. Columns will now appear on one page, but the rows may extend to more than one page.

How do I split an Excel spreadsheet into two files?

Split a workbook to separate Excel Files with Move or Copy feature

1. Select the sheets in the Sheet tab bar, right click, and select Move or Copy from the context menu.
2. In the Move or Copy dialog, select (new book) from the To book drop down list, check the Create a copy option, and click the OK button.

How do I get my Excel spreadsheet to fill the whole 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.

How do I see the Page Layout in Excel?

To access Page Layout view, locate and select the Page Layout view command in the bottom-right corner of your workbook.

How many pages are there in a worksheet?

For example, if your workbook contains two worksheets that are both two pages long, the first worksheet will contain two pages numbered 1 and 2. The second worksheet will also contain two pages numbered 1 and 2.

Where are the page numbers on an Excel spreadsheet?

If you want numbers shown on pages when you print a Microsoft Excel worksheet, you can insert page numbers in the headers or footers of the worksheet pages. Page numbers that you insert are not displayed on the worksheet in Normal view— they are shown only in Page Layout view and on the printed pages.

How are page breaks inserted in an Excel spreadsheet?

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. A page break is inserted.

Which is the work area of an Excel spreadsheet?

It contains data manipulation, data visualizing toolbar, page layout tools and many more. Spreadsheet Work Area: It is by default a grid which contains alphabetic column A, B, C, …, Z, ZA…, ZZ, ZZA… and rows as Numbers 1,2, 3, …. 100, 101, … so on. It is a cell where the user can perform his calculation for personal or business data.