Sunday, December 31, 2017

Page Setup

Page Setup

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 Button image .

Page Setup Dialog Box Launcher

Page Setup > Page options

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.

First page number    In this box, enter Auto to start numbering pages at "1" (if it is the first page of the print job) or at the next sequential number (if it is not the first page of the print job). Enter a number to specify a starting page number other than "1."

Top of Page

Page Setup > Margin options

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 pageCenter the data on the page within the margins by selecting the Vertically check box, the Horizontally check box, or both.

Top of Page

Page Setup > Header and Footer options

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.

Top of Page

Page Setup > Sheet options

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 Collapse 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 Collapse 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.

  • Row and column headings    Select the Row and column headings check box to include these headings in the printout.

  • Comments    In this box, select the location where you want annotations that you added to worksheet cells to appear in the printout. Select At end of sheet to combine all annotations and print them together on a page that is added at the end of the printout. Select As displayed on sheet to print the annotations in their original location on the worksheet. Annotations are not automatically included in the printout, because None is selected by default.

  • Cell errors as    In this box, select how you want cell errors that appear on the worksheet to be displayed in the printout. By default, errors are displayed as they appear, but you cannot display them by selecting <blank>, display them as a double hyphen by selecting --, or display them as #N/A.

Page order    Click Down, then over or Over, then down to control the order in which data is numbered and printed when it does not fit on one page. The sample picture previews the direction your document will print when you choose one of these options.

Top of Page

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Preview worksheet pages before printing

Print a worksheet or workbook

4 comments:

  1. Hello everyone,
    I will tell you a secret of getting rich on bitcoin investment “a wise person should have money in their head , but not in the heart.. Everyday is a day of new decisions. Its your choice to be rich or to be poor & keep struggling, start making larger funds in 72 hours with a legit & pro trader like me,Investment plans are open now with a minimum investment of $200 you can earn $2000 in 72 hours.

    Invest $200 earn $2,000
    Invest $500 earn $5,000
    Invest $700 earn $7,000
    Invest $1,000 earn $10,000
    Invest $2,000 earn $20,000
    Invest $5,000 earn $50,000
    Invest $7,000 earn $70,000

    Do not miss this clear opportunity to achieve your financial freedom, those who are not ready to invest now are not ready to retire early, do not depend on a single source of income, let us trade for you today and start making profit for you. Kindly contact us Via WhatsApp: +1(252)285-2093 Email : andersoncarlassettrade@gmail.com

    ReplyDelete
  2. Microsoft Office Tutorials: Page Setup >>>>> Download Now

    >>>>> Download Full

    Microsoft Office Tutorials: Page Setup >>>>> Download LINK

    >>>>> Download Now

    Microsoft Office Tutorials: Page Setup >>>>> Download Full

    >>>>> Download LINK gK

    ReplyDelete
  3. Hello, I'm here to testify of how i got my real estate business loan amount €564,000.00 from Prof.Cindy Alberto Kauk. I don't know if you are in need of an urgent loan to pay bills, start business or build a house, they offer all kinds of loan Ranging from $5,000.00USD to $2,000,000.00USD with a low interest rate of 2% and loan duration of 1 to 33 years to pay back the loan secure and unsecured. Are you losing sleep at nights worrying how to get a Legit Loan Lender?
    Mrs.Cindy Alberto Kauk holds all of the information about how to obtain money quickly and painlessly without cost/stress via Contacts
    WHATS-APP NUMBER +79067089453 Email profcindyinvestments@hotmail.com

    They offer all kind of categories of loans

    Short term loan (1_10years)
    Long term loan (20_33 years)
    They offer loan like
    Home loan............., Business loan........ Debt consolidation loan .......
    Student loan..........,Business start up loan
    Business loan....... , Company loan..............Mortgages loan
    construction loan.....car loan........ hotel loan....personal loans..
    Investment Loan.......Commercial Loan........Refinancing Loans
    Truck Loans............Farm Loan etc.

    Email..........(profcindyinvestments@hotmail.com) WHATS-APP NUMBER +79067089453
    When it comes to financial crisis and you need to be free from
    financial crisis then MRS.CINDY ALBERTO is the right answer...

    ReplyDelete
  4. <<<<<<<<<<>>>>>>>>>>>>>><<<
    <<<<<<<<<<>>>>>>>>>>>>>>>.
    <,,<,,J%^^^^^&&&&&&&&^^^^^^^^
    Hello there, as a newbie to crypto currency trading, I lost a lot of money trying to navigate the market on my own. In my search for a genuine and trusted trader, i came across Mr Bernie Doran who guided and helped me make so much profit up to the tune of $40,000. I made my first investment with $1,000 and got a ROI of $9,400 in less than 8 days. You can contact this expert trader via Gmail bernie.doranfx01@gmail.com or on WhatsApp +1(424)285-0682 and be ready to share your own

    ReplyDelete