Copy page setup excel 2003

To center within the top and bottom margins, under Center on page , select Vertically. Was this article helpful? Yes No. This article is based on legacy software.

Changing the Orientation Most documents are portrait tall oriented, but many worksheets may be easier to read in the landscape wide mode. Select the Page tab. Click OK. Macintosh: From the File menu, select Page Setup Excel defaults to no header and no footer.

You can insert placeholder buttons into both the header and footer to format text and insert page numbers, dates, times, file names, and tab names. Excel replaces these placeholders with the information each represents when the worksheet is printed.

Follow the instructions in the Header and Footer dialog boxes. The Sheet tab in the Page Setup dialog box provides additional print options that you may want to add to your worksheet. By default, Excel prints from the A1 to the last occupied cell in a worksheet.

You can specify a different range of cells to print. Prints column and row labels on each page of the printout. This determines whether gridlines are printed. However, turning off gridlines does not affect their appearance in Normal View.

If you used colors in your worksheet but don't want to waste the ink in your color printer, use black and white.

Excel Defining Page Setup Options. Introduction By the end of this lesson, you should be able to: Set page margins Change page orientation and paper size Create headers and footers Create sheet settings.

Setting page margins The page margins define where on the page Excel will print the worksheet. To change the margins in the Page Setup dialog box: Select the correct worksheet. Choose File Page Setup from the menu bar. Preview worksheet pages before printing. Print a worksheet or workbook. Top of Page. Related links Repeat specific rows or columns on every printed page Top of Page.

Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Then click OK to copy and apply the page settings to the checked worksheets.

And the worksheets will have the same page setups. Print multiple workbooks in Excel. Print ranges in Excel. Quickly print current page in Excel. Print long column on one page in Excel. Note: The other languages of the website are Google-translated. Back to English. Log in. Remember Me Forgot your password?