{"id":1455,"date":"2022-12-13T20:28:50","date_gmt":"2022-12-13T20:28:50","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=1455"},"modified":"2024-01-19T21:45:06","modified_gmt":"2024-01-19T21:45:06","slug":"how-to-print-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-print-in-excel\/","title":{"rendered":"How to Print in Excel \u2013 Step-by-Step Guide?"},"content":{"rendered":"

Print in Excel with confidence and precision by mastering the nuances of setting up your spreadsheets for optimal printing. Whether you’re preparing a financial report, a statistical analysis, or a project plan, knowing how to correctly configure your pages can make all the difference in how your hard work is presented on paper. This step-by-step guide will take you through the process of preparing your Excel documents for printing, from adjusting margins and layout to ensuring that your data is displayed cleanly and comprehensively. By honing your skills to print in Excel, you’ll ensure that your printed spreadsheets are as clear, impactful, and professional as the data they contain.<\/p>\n

This Tutorial Covers:<\/strong><\/p>\n

    \n
  1. How to print in Excel<\/strong><\/a><\/li>\n
  2. Print selection, Whole sheet, or the entire workbook<\/strong><\/a><\/li>\n
  3. Print the spreadsheet on one page <\/strong><\/a><\/li>\n
  4. Print to file to save the output for later use<\/strong><\/a><\/li>\n
  5. Print Preview in Excel<\/strong><\/a><\/li>\n
  6. Excel Print Options<\/strong><\/a><\/li>\n
  7. Setting Print Area and how to remove the existing print area<\/strong><\/a><\/li>\n
  8. Insert Page break and remove page break<\/strong><\/a><\/li>\n
  9. Insert Page Numbers and print page numbers in Excel<\/strong><\/a><\/li>\n
  10. Print Formulas<\/strong><\/a><\/li>\n
  11. How to print Excel Chart<\/strong><\/a><\/li>\n
  12. Print with gridlines in Excel<\/strong><\/a><\/li>\n
  13. Print the header on each page<\/strong><\/a><\/li>\n
  14. Print multiple sheets in Excel<\/strong><\/a><\/li>\n
  15. Print all sheets in Excel<\/strong><\/a><\/li>\n<\/ol>\n

    1. How to print in Excel?<\/strong><\/h2>\n

    The procedure for printing Excel spreadsheet:<\/strong><\/p>\n

    Step 1:<\/strong> Navigate to the Excel Sheet that the user wants to print. Open the File menu bar, then select Print or press Ctrl + P on the keyboard, outlined in Red below.<\/p>\n

    \"Print
    Print in Excel<\/figcaption><\/figure>\n

    Step 2:<\/strong> Click “Next Page” or “Previous Page” at the bottom of the window to see a preview of the other pages that will be printed, outlined in Red below.<\/p>\n

    \"Print
    Print in Excel<\/figcaption><\/figure>\n

    Step 3:<\/strong> Enter the number of copies you want in the \u201cCopies\u201d box, outlined in Red below.<\/p>\n

    \"Print\"<\/p>\n

    Step 4:<\/strong> Choose the printer you want to use under the \u201cPrinter\u201d section, outlined in Red below.<\/p>\n

    \"Print\"<\/p>\n

    Step 5:<\/strong> Set the page margins, orientation, paper size, and other printing options under the \u201cSettings\u201d section, outlined in Red below.<\/p>\n

    \"Print
    Print in Excel<\/figcaption><\/figure>\n

    Step 6<\/strong>: Simply click the large \u201cPrint\u201d button to print the worksheet, outlined in Red below.<\/p>\n

    \"Print\"<\/p>\n

    2. Print selection, Whole sheet, or entire workbook<\/strong><\/h2>\n

    Click the arrow next to \u201cPrint Active Sheets\u201d in the Settings section of Excel and select one of the following options to instruct the program which data and objects should be printed:<\/p>\n

    \"Print\"<\/p>\n

    The settings in the screenshot above are individually briefly described below, along with instructions on how to utilize them.<\/p>\n

    Print the entire page (s):<\/strong><\/p>\n

    Select Print Active Sheets to print the whole sheet that is open at the moment.<\/p>\n

    Print the entire workbook:<\/strong><\/p>\n

    Select Print Entire Workbook to print every sheet in the active workbook.<\/p>\n

    Print selection:<\/strong><\/p>\n

    Highlight a specific cell range on the sheet, then select Print Selection to print only that range of cells. Hold down the Ctrl key when selecting to choose cells or ranges that are not adjacent.<\/p>\n

    Hold down the Ctrl key as you click on the sheet tabs to print several sheets, and then select Print Active Sheets.<\/p>\n

    Print Excel table:<\/strong><\/p>\n

    Click any cell in your Excel table, then select Print Selected Table from the menu that appears. Only when the table or a portion of it is selected does this option show.<\/p>\n

    3. Print the spreadsheet on one page <\/strong><\/h2>\n

    Excel prints sheets at their true size by default. Therefore, your worksheet will require more pages the larger it is.\u00a0<\/strong><\/p>\n

    Step 1:<\/strong> Navigate to the Excel Sheet that the user wants to print. Open the File menu bar, then select Print or press Ctrl + P on the keyboard, outlined in Red below.<\/p>\n

    \"Print<\/p>\n

    Step 2:<\/strong> Select the appropriate Scaling options listed below, which are located at the bottom of the \u201cSettings\u201d tab in the Print Preview window, to print an Excel sheet on one page.<\/p>\n

    \"Print\"<\/p>\n

    Fit Sheet on One Page:<\/strong> This will shrink the Sheet to fit on a single page.<\/p>\n

    Fit All Columns on One Page:<\/strong> This will print all the columns on a single page, but the rows may be spread out across multiple pages.<\/p>\n

    Fit All Rows on One Page:<\/strong> This will print all of the rows on a single page, although the columns may take up multiple pages.<\/p>\n

    No Scaling: <\/strong>Select \u201cNo Scaling\u201d from the list of choices to get rid of scaling.<\/p>\n

    Please use extreme caution while printing on one page because your printout can become unreadable on a large sheet. Click Custom Scaling Options… to see how much actual scaling will be applied. When the Page Setup dialog box appears, you can check the number in the Adjust to box by clicking on it:<\/p>\n

    \"Print\"<\/p>\n

    It will be challenging to read a printed copy if the Adjust To number is low. The modifications listed below in this situation might be helpful:<\/p>\n

      \n
    1. Change page orientation. When there are more rows than columns in a worksheet, the default Portrait orientation works nicely. Change the page orientation to Landscape if your document has more columns than rows.<\/li>\n<\/ol>\n

      \"Print<\/p>\n

      2. Adjust the margins. Your dataset will have more room if somehow the margins are narrower.<\/p>\n

      \"Print\"<\/p>\n

      3. Indicate how many pages there are. Enter the desired number of pages in both Fit to boxes under Scaling on the Page tab of the Page Setup dialog in order to print an Excel spreadsheet on a certain number of pages (wide and tall). Please be aware that any manual page breaks will be ignored if you choose this option.<\/p>\n

      \"Print\"<\/p>\n

      4. Print to file to save the output for later use<\/strong><\/h2>\n

      One of the least often utilized Excel print functions is Print to File, which many people underrate. In a nutshell, this option saves the output to a file rather than printing it.<\/p>\n

      Why would you want to print a document to keep? when numerous printed copies of the same document are required in order to save time. The concept is to just set the print preferences once\u2014margins, orientation, page breaks, etc.\u2014and then save the result as a a.pdf file. The following time you require a printed copy, just open that.pdf file, and select Print.<\/p>\n

      These are the steps to do \u201cPrint to file\u201d to save the output for later use:<\/strong><\/p>\n

      Step 1<\/strong>: \u00a0Navigate to the Excel Sheet that the user wants to print. Open the File menu bar, then select Print or press Ctrl + P on the keyboard, outlined in Red below.<\/p>\n

      \"Print\"<\/p>\n

      Step 2:<\/strong> Select \u201cPrint to File\u201d from the Printer drop-down list in the Print Preview box, outlined in Red below.<\/p>\n

      \"Print\"<\/p>\n

      Step 3:<\/strong> Simply click the large \u201cPrint\u201d button and save the file as the desired format in your desired location<\/p>\n

      \"Print\"<\/p>\n

      5. Print Preview in Excel<\/strong><\/h2>\n

      To prevent unexpected outcomes, it is always a good idea to preview outputs before printing. There are two ways to use Excel’s print preview feature:<\/p>\n