How to change print area in excel after making one page

Choose Insert > Page Number, Page Count, or Date & Time (from the Insert menu at the top of your screen).Д¬hange the look of header and footer text: Select the text, click Text at the top of the Print Setup sidebar, then choose formatting options. Insert a page number, page count, or date & time in a header: Move the pointer over a sheet thumbnail in the grid on the left, then click in the header field. You must add headers to each sheet where you want them. To add and edit a header, do any of the following:ДЄdd text in a header: Move the pointer over a sheet thumbnail in the grid on the left, then click and type in the header field that appears. Page Margins: Enter values or click the arrows next to Top and Bottom to set the page margins. Page Order: Choose whether pages are numbered top to bottom, then left to right, or left to right, then top to bottom. All the time, the user does not need to print the. If you donвЂ™t want a page number to print on a specific sheet, click the center of the footer on the sheet thumbnail in the grid on the left, select the page number, then press Delete on the keyboard. Generally, when the Ctrl+P key (print command) is pressed in Excel the entire page gets printed by default. To continue page numbers from the previous sheet, select вЂњContinue from previous sheet.вЂќ If you select вЂњStart at,вЂќ type a starting page number. Page numbers: Page numbers are printed by default. If you turn off sheet backgrounds, all text colors for the sheet are changed to black. Print sheet background: Select the checkbox to print sheet backgrounds. Comment flags on the sheet are numbered to correspond with the comments on the comment page. Comments appear on a separate page that follows the sheet. Print comments: Select the checkbox to print comments. Repeat table headers: Select the checkbox to print table headers on every page where the table appears. (If you open a spreadsheet from Numbers вЂ09, Fit is turned off by default.) To fit content to the width of a page again, click Fit. To display content across multiple pages, drag the slider to adjust the scale. If you donвЂ™t already have a printer set up, open System Preferences, click the back arrow at the top of the System Preferences window, click Printers & Scanners, then follow the instructions.Д¬lick the paper size pop-up menu and choose an option.Д¬ontent Scale: By default, Numbers scales your content so that it fits the width of one page. The Print Setup sidebar opens on the right and your spreadsheet appears in a blue grid on the left.Д¬lick the printer pop-up menu and choose a printer. Open the spreadsheet and choose File > Print. Restore an earlier version of a spreadsheet.Save a large spreadsheet as a package file.Place objects inside a text box or shape.Format Chinese, Japanese, or Korean text.Use a keyboard shortcut to apply a style.Create, rename, or delete paragraph styles.Bold, italic, underline, and strikethrough.Format a spreadsheet for another language.Select text and place the insertion point.

Add a legend, gridlines, and other markings Then go to Sheet and click on options>Paper size>Manage custom sizes and enter the page size you want, click ok then click ok in page setup.

Add column, bar, line, area, pie, donut, and radar charts.

Calculate values using data in table cells.

Quickly calculate a sum, average, and more.

Select FilePage Setup, then in the Scaling area select Fit to.

View the source data for a pivot table value If desired you can scale your content to make it fit on a page.

Change how pivot table data is sorted, grouped, and more.

Add calculations to summarize group data.

Add checkboxes and other controls to cells.

Use VoiceOver to create formulas and autofill cells.

Intro to images, charts, and other objects.

Choose the Number of copies to print by clicking the up or down arrows.Дon't print your Excel spreadsheet without checking spelling first! Excel includes two tools to help correct spelling errors: AutoCorrect and Spelling.

In Print what, choose whether to print a Selection, the Active sheet, or the Entire Workbook (all worksheets in the workbook).

In Print Range, choose whether to print All or a certain range of pages ( Pages From n to y, where n and y are the beginning and ending page numbers).

If you only have one printer in your home or office, Excel will default to that printer.

Specify the printer name where the spreadsheet will print. After selecting the area you want to print out, go to Page layout > Print Area > Set Print Area.

As previously mentioned, Excel defaults to printing the entire worksheet. Printing in Excel is much like printing in other Office applications such as Microsoft Word.

How to change print area in excel after making one page