Search results
Insert > Page Number > Format Page Numbers. This gives you correct numbers in any Table of Contents or Index. You can do a formula field. { = { PAGE } + 100 } If you are doing Page x of y format, you will want to use. { = { NUMPAGES } + 100 } even if you format your page numbers to start with 101.
- Overview
- Page tab options
- Margins tab options
- Header/Footer tab options
- Sheet tab options
- Need more help?
- See Also
Use the Page Setup dialog box to set up layout and print options of a page.
Click on the Page Layout tab, then in the Page Setup group, click the Dialog Box Launcher .
Orientation Choose between landscape and portrait.
Scaling Enlarges or reduces the worksheet or selection when you print so that it fits on the specified number of pages.
•Adjust to When you select Adjust to, you can enter a percentage in the % normal size box.
•Fit to When you select Fit to, you can enter a number in the page(s) wide by box and the tall box. To fill the paper width and use as many pages as necessary, type 1 in the pages(s) wide by box and leave the tall box blank.
Paper size In this box, click Letter, Legal, or other size options to indicate the size that you want to use for your printed document or envelope.
Print quality In this box, click a resolution to specify the print quality for the active worksheet. Resolution is the number of dots per linear inch (dpi) that appear on the printed page. Higher resolution produces better quality printing in printers that support high-resolution printing.
Enter margin settings and see the results in the Preview box.
•Top, Bottom, Left, Right Adjust measurements in the Top, Bottom, Left, and Right boxes to specify the distance between your data and the edge of the printed page.
•Header or Footer Enter a number in the Header box or the Footer box to adjust the distance between the header and the top of the page or between the footer and the bottom of the page. The distance should be smaller than the margin settings to prevent the header or footer from overlapping the data.
Center on page Center the data on the page within the margins by selecting the Vertically check box, the Horizontally check box, or both.
Header Click a built-in header in the Header box or click Custom Header to create a custom header for the worksheet that you want to print. The built-in header is copied to the Header dialog box, where you can format or edit the selected header.
Footer Click a built-in footer in the Footer box or click Custom Footer to create a custom footer for the worksheet that you want to print. The built-in footer is copied to the Footer dialog box, where you can format or edit the selected footer.
Different odd and even pages Select the Different odd and even Pages check box to specify that the headers and footers on odd-numbered pages should be different from those on even-numbered pages.
Different first page Select the Different first page check box to remove headers and footers from or to create custom headers and footers for the first printed page. To create a custom header or footer for the first page, select this check box, click Custom Header or Custom Footer, and then on the First Page Header or First Page Footer tab, you can add the header or footer information that you want to appear on the first page.
Scale with document Select the Scale with document check box to specify whether the headers and footers should use the same font size and scaling as the worksheet. This check box is selected by default. To make the font size and scaling of the headers or footers independent of the worksheet scaling to create a consistent display across multiple pages, clear this check box.
Align with page margins Select the Align with page margins check box to make sure that the header or footer margin is aligned with the left and right margins of the worksheet. This check box is selected by default. To set the left and right margins of the headers and footers to a specific value that is independent of the left and right margins of the worksheet, clear this check box.
Print area Click the Print area box to select a worksheet range to print, and then drag through the worksheet areas that you want to print. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells in the worksheet. After you finish, you can click the button again to display the entire dialog box.
Print titles Select an option under Print titles to print the same columns or rows as titles on every page of a printed worksheet. Select Rows to repeat at top if you want specific rows as your horizontal title for each page. Select Columns to repeat at left if you want vertical titles on each page. Then on the worksheet, select a cell or cells in the title columns or rows you want. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells in the worksheet. After you finish, you can click the button again to display the entire dialog box.
Print Specifies what is printed from the worksheet, whether the printout is in color or black and white, and what the print quality is.
•Gridlines Select the Gridlines check box to include worksheet gridlines in the printout. Gridlines are not printed by default, regardless of whether they are displayed on the worksheet or not.
•Black and white Select the Black and white check box when you use a color printer but you want to use black and white only when printing. This option is off by default. You do not have to select it when you are using a printer that prints black and white only.
•Draft quality Select the Draft quality check box to print faster by using less print quality when the printer that you use has a draft-quality mode. This option has no effect when the printer has no draft-quality mode.
You can always ask an expert in the Excel Tech Community or get support in Communities.
Preview worksheet pages before printing
Print a worksheet or workbook
- Using CONCATENATE Function for Page Number in Excel. If you’re in a hurry and have to insert page numbers in a handful of pages then our first method may come in handy.
- Using Ampersand Operator to Print Page Number in Excel. For our next method, we’ll use the Ampersand (&) operator to print the page number in Excel.
- Using Excel TEXTJOIN Function as Formula for Page Number. Another similar approach involves using the TEXTJOIN function to insert the page numbers.
- Using Insert Tab with Formula for Printing Page Number in Excel. For our second method, we’ll see the conventional approach of inserting page numbers in Excel worksheets.
Steps are as follows: Select the first cell you want to reference (make sure you select the whole cell, that seems to matter in my experimenting). Go to the INSERT tab on the ribbon, and under the LINKS drop-down select BOOKMARK. Add a named bookmark which will point to your cell. i.e. bookmark "A1". Repeat for each cell you'd like to create a ...
Aug 6, 2022 · Method 2: Add Formulas in a Table Cell in Word. Quickly insert a table in your Word document and populate the table with data. Navigate to the cell where you want to make your computations using a formula. Once you've selected the cell, switch to the Layout tab from the ribbon at the top and select Formula from the Data group.
Aug 9, 2021 · After you insert or draw your table in Microsoft Word and fill it with data, select the cell where you want to add the formula. Then, head to the Layout tab that appears. Move to the right side of the ribbon and click "Formula" in the Data section. When the Formula window opens, it's time to get to work on your quick calculation.
People also ask
How do I set up a page in Excel?
How do I use a formula in word?
How do I use a formula in Excel?
How to add a page number in Excel?
How to remove page numbers in Excel?
How do I update a formula in Microsoft Word?
2 days ago · Step 1: Access AutoFit Options. Click anywhere on your table to open the Table Tools. Then, go to the “Layout” tab. Step 2: Use AutoFit. Click on “AutoFit” in the Cell Size group.
