HomeApplicationOffice information

How to format and print Excel file page

To print the excel sheet properly and beautifully, after completing that excel sheet, we need to know the basics of page format and printing method. In order not to cause unfortunate mistakes in printing, help save time at work you can refer to the following article.

I Print page format

1. Pate: Set print page

  1. Orientation: Page orientation
  2. Portrait: Portrait paper
  3. Landscape: Horizontal page
  4. Scaling: Determine the ratio
  1. Adjust to: Adjust the print percentage
  2. Paper size: Select a paper size

2. Margins: Set the print margins

  1. Top: Top margin
  2. Header: The space for the title above
  3. Bottom: Bottom margin
  4. Footer: The space for the header below
  5. Left: Left margin
  6. Center on page: Align the worksheet to the middle of the page
  7. Right: Right margin
  8. Horizontally: Align the worksheet to the center of the page horizontally
  9. Vertical: Align the worksheet to the center of the page horizontally

3. Header / Footer: Create header and footer

  1. Custom header: Create a title above
  2. Custom footer: Create a header below

4. Sheet

  1. Print area: Select the print area
  2. Rows to repeat at top: Repeat the first subject line for the following pages
  3. Columns to repeat at left: Repeat the left column heading for the following.
  4. Gridlines: Print entire gridlines
  5. Row and columns heading: Print both row and column headings
  6. Down then over: Number the page vertically
  7. Over, then down: Number the page horizontally

II Printing

1. Print preview

  1. Method 1: File / Print preview
  2. Method 2: Click on the Print Preview icon on the Standard toolbar

2. In

  1. Method 1: Left-click the Print icon on the toolbar

  2. Method 2: File / Print (or Ctrl + P key combination)
  3. The Print dialog box appears
    1. Name: Select the name of the device to print
    2. All: Print all
    3. Page (s): Print from page .. to page ..
    4. Number of copies: Enter the number of copies to be printed.

How to format and print Excel file page Picture 1

4.5 ★ | 2 Vote

You should read it

May be interested

  • Set page margins in ExcelSet page margins in Excel
    show you how to set print margins in excel. setting margins for pages in excel is an indispensable operation for print jobs after calculations. to set the margins for the printed page, follow these steps: step 1: go to the home tab - pagelayout - click on the hat
  • Relax with 3 ways to print in this simple reverse orderRelax with 3 ways to print in this simple reverse order
    there is always a right way to print your documents. some inkjet printers print pages from the top, which means you have to manually reverse the print order. this is not a problem when printing only a few pages, but when you print a few hundred pages of documents then you need a trick to print them in reverse order so you can arrange them neatly.
  • How to print Excel on 1 A4 page - Display full content on 1 pageHow to print Excel on 1 A4 page - Display full content on 1 page
    when printing an excel file, if the content is long and converted to 2 printed pages, how can i display the excel document content on only 1 a4 page?
  • Perform printing in ExcelPerform printing in Excel
    guide you to perform printing in excel. after setting up the page to print the final step, you can manipulate to print the worksheet in excel. step 1: after setting up the worksheet - click file - print: step 2: the print window appears in pa section
  • Text file formatText file format
    many times you are struggling to know how to shoot a horizontal page in a whole page of text. or every time you create a new file you have to reformat the text for the page even though the previous and next margin sizes do not change, etc. tipsmake.com will guide you on how to format the page margins, rotate the horizontal page, vertical page
  • Instructions on how to choose the print area in ExcelInstructions on how to choose the print area in Excel
    excel sheets are inherently an interface with data stretching both horizontally and vertically so when printing you will have a few issues worth mentioning. for example, separate print page content or print area limits. today we will talk about one of those issues with tipsmake, which is how to choose the print area in excel.
  • How to print parity pages in ExcelHow to print parity pages in Excel
    printing parity pages in excel will not be as simple as printing parity in word because it does not have odd pages or even pages functionality. so to make a parity page print in excel, we need to follow a different method. before you can even print odd pages in excel, you need to check the page numbering
  • How to fix the error of printing without finishing the page in ExcelHow to fix the error of printing without finishing the page in Excel
    need to print a table of data in excel? but the data sheet is divided into 2 pages causing inconvenience to you? click to see now to find out how to fix it quickly and effectively!
  • How to print multiple sheets in ExcelHow to print multiple sheets in Excel
    print sheets in excel file can choose to print multiple sheets or print all sheets with a simple and very easy way.
  • How to Insert a Page Break in an Excel WorksheetHow to Insert a Page Break in an Excel Worksheet
    if you've ever tried printing a large microsoft excel worksheet, you've undoubtedly encountered some awkward-looking print jobs. excel's automatic page breaks don't exactly take your custom data views into consideration. in order to...

Office information