How to Print in Excel Neatly - Compute Expert

How to Print in Excel Neatly


Home >> Excel Tutorials from Compute Expert >> Excel Tips and Trick >> How to Print in Excel Neatly





In this tutorial, you will learn how to print in excel the right way.

When working with an excel document, we sometimes need to print so we can get the document’s hardcopy version. We might need to show it to our colleagues so they can discuss the content with us.

Excel has some features related to printing that you should master so you can print your excel document neatly. Want to understand how to utilize those printing features in excel optimally? Need to get your excel document hardcopy in the way you prefer but you don’t know how to do it? Read all parts of this tutorial!

Disclaimer: This post may contain affiliate links from which we earn commission from qualifying purchases/actions at no additional cost for you. Learn more

Want to work faster and easier in Excel? Install and use Excel add-ins! Read this article to know the best Excel add-ins to use according to us!

Learn Excel Dashboard Course






How to Print in Excel: Step-by-Step

To start, let’s discuss the steps to print an excel document first. These steps are quite straightforward so you should be able to follow them easily.

  1. In the excel file that you want to print, click File and choose Print. Alternatively, you can also just press Ctrl + P (Command + P on Mac)

    How to Print in Excel Neatly - Screenshot of Step 1

  2. Manage the print settings according to the printing process and result you prefer. You can see more discussion about the print settings in excel in the next parts of this tutorial

    How to Print in Excel Neatly - Screenshot of Step 2

  3. If the settings already look good, click Print

    How to Print in Excel Neatly - Screenshot of Step 3

  4. Done! Your printer should begin to process the hardcopy version of your excel document now



How to Manage Excel Print Settings

You may get confused with all the print settings you can manage in the excel print menu. What do they mean and how do they affect your printing process and result? Here is a bit explanation about them so you can manage your print settings correctly according to the way you prefer.

How to Print in Excel Neatly - Screenshot of the Copies Settings

Copies: How many copies of hardcopy you want to print from your excel document.

How to Print in Excel Neatly - Screenshot of the Printer Settings

Printer: From which printer you want to print your excel document.

How to Print in Excel Neatly - Screenshot of the Scope Settings

Scope:
  • Print Active Sheets: Print only the worksheet you currently activate
  • Print Entire Workbook: Print all the worksheets in your current excel workbook
  • Print Selection: Print only the cells you currently highlight


How to Print in Excel Neatly - Screenshot of the Pages Settings

Pages … to ….: From which page to which page you want to print your worksheet. You can manage your worksheet’s pages in the page break preview menu.

If you don’t do anything on this setting, then excel will print all the contents in your current printing scope.

How to Print in Excel Neatly - Screenshot of the Paper Sides Settings

Paper Sides:
  • Print One-Sided: Print only on one side of your papers
  • Print on Both Sides (Flip Pages on Long Edge): Print on both sides of your papers. Excel will assume people will turn pages in your document from left to right and print your document accordingly
  • Print on Both Sides (Flip Pages on Short Edge): Print on both sides of your papers. Excel will assume people will turn pages in your document from top to bottom and print your document accordingly


How to Print in Excel Neatly - Screenshot of the Collated Settings

Collated/not:
  • Collated: If you print multiple copies of your document, then excel will print them per copy (e.g. will begin by printing copy 1, and then copy 2, and so on)
  • Uncollated: If you print multiple copies of your document, then excel will print them per page (e.g. will begin by printing all page 1 of the copies, then all page 2 of the copies, and so on)


How to Print in Excel Neatly - Screenshot of the Using Staples Settings

Using staples/not: If your printer can staple, then tell excel which side you want to place staples in your pages. If your printer can’t staple or you don’t want to staple your papers, choose “No Staples”.

How to Print in Excel Neatly - Screenshot of the Orientation Settings



Orientation:
  • Portrait Orientation: Print your document to your papers in a portrait orientation
  • Landscape Orientation: Print your document to your papers in a landscape orientation


How to Print in Excel Neatly - Screenshot of the Paper Size Settings

Paper size: Determine the size of the papers you will print your document into. Excel will fit the document according to the paper size you choose.

How to Print in Excel Neatly - Screenshot of the Margin Settings

Margin: Determine the distance between the edge of your paper and the edge of content in the excel document you print.

How to Print in Excel Neatly - Screenshot of the Scaling Settings

Scaling:
  • No Scaling: Print according to the actual size of all the contents in your excel document
  • Fit Sheet on One Page: Print all the contents in your excel document into one page
  • Fit All Columns in One Page: Print all the content columns in your excel document into one page
  • Fit All Rows in One Page: Print all the content rows in your excel document into one page
  • Custom Scaling Options…: Customize the scaling of the contents in your excel document for the printing purpose


Choose the correct settings according to the printing result you want from your excel document!


How to Set Print Area in Excel

The print area is the part that excel will print for you when you print your worksheet. By default, Excel will print all the part of your worksheet that has data in it.

However, if you want to determine the print area yourself, then you can follow these steps.

  1. Highlight the cell range in your worksheet that you want to set as the print area

    How to Print in Excel Neatly - Screenshot of How to Set Print Area, Step 1

  2. Go to the Page Layout tab, click the Print Area button, and choose Set Print Area

    How to Print in Excel Neatly - Screenshot of How to Set Print Area, Step 2

  3. Done! You have set the cell range you highlight as your worksheet’s print area


If you want to go back to the default print area, then click the Print Area button again. Then, choose Clear Print Area.

How to Print in Excel Neatly - Screenshot of the Clear Print Area Choice Location



How to Set Pages to Print in Excel

Want to manage the pages division for your printing process in excel? You can do that in the page break preview interface in excel.

To activate that interface, go to the View tab and click the Page Break Preview button on the left. You will activate the interface from where you can set the pages in your worksheet.

How to Print in Excel Neatly - Screenshot of the View Tab and Page Break Preview Button Locations

In the interface, you will see blue horizontal and vertical dashed lines as the boundaries between your pages.

How to Print in Excel Neatly - Screenshot of the Page Break Preview Interface

Just move your pointer to the relevant lines and drag them to set your worksheet’s pages to the way you prefer.



Want to go back to the normal worksheet interface? Just go to the View tab again and click the Normal button there.

How to Print in Excel Neatly - Screenshot of the Normal Button Location



How to Insert Page Breaks in Excel

Need to insert a page break in your worksheet? Follow these easy steps to do it.

  1. Go to the View tab and click the Page Break Preview button. You can insert page breaks without going to the page break preview interface. However, you better go there while setting your page breaks so you can see the result clearly

    How to Print in Excel Neatly - Screenshot of How to Insert Page Breaks, Step 1

  2. Highlight the column/row where you want to insert your page break

    How to Print in Excel Neatly - Screenshot of How to Insert Page Breaks, Step 2

  3. Go to the Page Layout tab, click the Breaks button there, and choose Insert Page Break

    How to Print in Excel Neatly - Screenshot of How to Insert Page Breaks, Step 3

  4. Done! You have inserted a page break to the worksheet part you highlight.

    How to Print in Excel Neatly - Screenshot of How to Insert Page Breaks, Step 4

    If you need to insert other page breaks, repeat steps 2-3 until you have inserted all of them



How to Print in Excel so There Won’t Be Any Cut

To print your content without a page cut, you need to check your scaling setting when you print. From the available settings, choose:
  • Fit Sheet on One Page, if you don’t want excel to cut the rows and columns in the content you print
  • Fit All Columns on One Page, if you don’t want excel to cut the columns in the content you print
  • Fit All Rows on One Page, if you don’t want excel to cut the rows in the content you print


How to Print in Excel Neatly - Screenshot of the Scaling Setting Choices to Avoid Cuts in Our Print Result

Choose the scaling content that fits into your needs so there won’t be any unnecessary cut to your content.



How to Print in Excel so the Font Won’t Be Small

You can check the actual font size you will get in the print preview next to your print settings. If it is too small (or too big), then you need to adjust the scaling setting of your printing. Logically, the more content you fit into your page, the smaller font size you will get.

If you want to manually adjust your scaling so your font can be bigger, then choose the Custom Scaling Options option.

How to Print in Excel Neatly - Screenshot of the Custom Scaling Options Choice in the Scaling Settings

In the dialog box that shows up, change the number in the “Adjust to” text box.

How to Print in Excel Neatly - Screenshot of the Adjust to Text Box in the Custom Scaling Options Dialog Box

Change it until you get the font size you want. To check the font size you get from your current scaling adjustment, take a look at the print preview again.



How to Print in Excel on One Page (Fit to One-Page Settings)

To fit all content you want to print into one page, choose Fit Sheet on One Page in your scaling setting.

How to Print in Excel Neatly - Screenshot of the Fit Sheet on One Page Scaling Settings

However, be careful as the more content you fit into one page, the smaller they will get on your page!




How to Print Selection in Excel

To print only a selected part of your worksheet in excel, highlight the cell range which contains the part first. Then, go to your print settings page and choose the Print Selection scope setting.

How to Print in Excel Neatly - Screenshot of the Print Selection Scope Settings

Click the Print button after that and you will only print the content in the cell range you highlight!



How to Print Selected Worksheets in Excel

To print several of your worksheets, select the worksheet tabs you want to print first. You can find the worksheet tabs on the bottom left of your workbook.

How to Print in Excel Neatly - Screenshot of Worksheet Tabs Location

You can select multiple adjacent worksheet tabs by clicking the tab on the most left/right of the adjacent tabs first. Then, hold the Shift button while clicking the worksheet tab on the opposite end of the adjacent tabs. The result will be something like this (see the red box).

How to Print in Excel Neatly - Screenshot of the Adjacent Worksheet Tabs Selection Result Example

If you want to select non-adjacent worksheet tabs, then hold the Ctrl button (command button in Mac) while clicking on those worksheet tabs. The result will be something like this (see the red boxes).

How to Print in Excel Neatly - Screenshot of the Non-Adjacent Worksheet Tabs Selection Result Example

After selecting the worksheets you want to print, go to the print settings page. Set the settings according to your preference and click the Print button. Excel should print the worksheets you selected after that!



How to Print the Same Cell Range from Multiple Sheets

Need to print the same cell range from multiple worksheets? You can combine the previous methods to print a selected cell range and worksheets to do this. Here are the steps.

  1. Highlight the cell range you want to print from the multiple worksheets in your current worksheet

    How to Print in Excel Neatly - Screenshot of How to Print the Same Cell Range from Multiple Sheets, Step 1

  2. Select the tabs of the worksheets you want to print by using the Shift or Ctrl button. Refer to our previous discussion if you don’t know how to do that

    How to Print in Excel Neatly - Screenshot of How to Print the Same Cell Range from Multiple Sheets, Step 2

  3. Go to the print settings page by clicking File and choose Print or by pressing Ctrl + P (Command + P in Mac). Choose the Print Selection scope setting there. Set the other print settings in the way that you prefer

    How to Print in Excel Neatly - Screenshot of How to Print the Same Cell Range from Multiple Sheets, Step 3

  4. Click the Print button after you have done your print settings. You will print the same cell range from all the worksheets which tabs you selected!



How to Print the Entire Workbook/All Sheets in Excel

To print all the worksheets in your excel workbook, you can just select Print Entire Workbook in your print scope setting.

How to Print in Excel Neatly - Screenshot of the Print Entire Workbook Scope Settings

Click the Print button after that and you will begin to print all the worksheets in your workbook!




How to Print to File

Want to save your current printing content and settings so it is ready to print later? You can print them to file first and place the file to somewhere you can access later.

Here are the steps to do that.

  1. In the excel file you want to create the printing file from, click File and then Print or press Ctrl + P (Command + P in Mac)

    How to Print in Excel Neatly - Screenshot of How to Print to File, Step 1

  2. In the printer setting in your print settings page, choose Print to File

    How to Print in Excel Neatly - Screenshot of How to Print to File, Step 2

  3. Click the Print button

    How to Print in Excel Neatly - Screenshot of How to Print to File, Step 3

  4. In the Save Print Output As dialog box, browse to the folder where you want to save your file. Type your file name in the text box and then click Save

    How to Print in Excel Neatly - Screenshot of How to Print to File, Step 4

  5. Wait until excel successfully creates your file. Your printing file is now available at the folder you save it to



How to Print with Title in Excel

Need to make several rows’ contents as the title for every page that you print from an excel worksheet? Here are the steps to set that title.

  1. Go to the Page Layout tab and click the Print Titles button there

    How to Print in Excel Neatly - Screenshot of How to Print with Title, Step 1

  2. In the dialog box that shows up, make sure you are in the Sheet tab. Then, click the button in the “Rows to repeat at top” text box on the tab page

    How to Print in Excel Neatly - Screenshot of How to Print with Title, Step 2

  3. Drag across the rows you want to set as the title when you print later. Excel will automatically input the row coordinates you drag into the text box. Click the button in the text box after you finish inputting the rows

    How to Print in Excel Neatly - Screenshot of How to Print with Title, Step 3

  4. You can also set the columns to repeat on every page in the “Columns to repeat at left” text box. Click the OK button after you have finished setting the title

    How to Print in Excel Neatly - Screenshot of How to Print with Title, Step 4

  5. Done! Now, whenever you print the worksheet, the rows you set earlier should become the title on your every page



How to Print in Excel with Lines/Gridlines

By default, Excel doesn’t print its gridlines to your pages whenever you print your worksheet. If you need to print them, however, then you can activate its print setting.



Do that by going to the Page Layout tab in your excel workbook first. Then, click on the Gridlines Print checkbox there to give a checkmark.

How to Print in Excel Neatly - Screenshot of the Gridlines Print Checkbox Location

Now, whenever you print the worksheet, Excel will print its gridlines too! If you don’t want to print them anymore, just click on the Gridlines Print checkbox again to remove the check mark.



How to Print Formulas in Excel

Need to print the formulas in your worksheet cells instead of their results? You can do that easily by showing those formulas before you print.

To show them, just press Ctrl + ` when you are in the worksheet from which you want to print your formulas. You can also go to the Formulas tab and click on the Show Formulas button there.

Before showing the formulas

How to Print in Excel Neatly - Screenshot of the Worksheet Interface Before Showing the Formulas

After showing the formulas

How to Print in Excel Neatly - Screenshot of the Worksheet Interface After Showing the Formulas

To hide the formulas again, just press Ctrl + ` or click on the Show Formulas button again.



How to Print Charts in Excel

If you have excel 2013 onwards, then you can print only a chart and not anything else from your worksheet. To do that, just select the chart you want to print first by clicking on it.

Then, go to the print settings page by clicking the File and the Print button or press Ctrl + P (Command + P in Mac). In the scope setting there, choose Print Selected Chart.

After that, click the Print button. Your printer will then begin to print the chart you selected!



How to Print Comments in Excel

Want to print the comments you have in your worksheet? You may need to read them in a hardcopy form so you can work on them better.

By default, Excel doesn’t print the comments you have in your worksheet cells. However, you can change that by managing its settings in your Page Setup menu.

To access that menu, go to the Page Layout tab and click the Page Setup button there. You can also access it from your print settings page by clicking on the Page Setup button available there.



Excel Page Setup button in the Page Layout tab

How to Print in Excel Neatly - Screenshot of the Page Setup Button Location in the Page Layout Tab

Excel Page Setup button in the print settings page

How to Print in Excel Neatly - Screenshot of the Page Setup Button Location in the Print Settings Page

In the dialog box that shows up after you click the Page Setup button, go to the Sheet tab. On the tab page, you will see a dropdown with the Comments label.

Click on the dropdown and choose either “At end of sheet” or “As displayed on sheet”. Choose “At end of sheet” if you want to print the comments on a separate page from your worksheet contents. You will get the comments’ cell coordinate and the person name who writes it on that separate page.

To print the comments as they are, choose “As displayed on sheet”.

How to Print in Excel Neatly - Screenshot of the At end of sheet and As displayed on sheet Choices in the Comments Dropdown

After you set the Comments dropdown, click OK. Now, when you print the worksheet, you will print its comments too!



How to Add a Print Command Button in Excel

If you need a button to access the printing function faster, you can add it to your quick access toolbar. Just click the quick access toolbar dropdown and check “Print” there by clicking on it if it is currently unchecked.

How to Print in Excel Neatly - Screenshot of the Quick Access Toolbar Dropdown Button and Its Print Choice Locations

Doing that will add the “Print” command button in your quick access toolbar! Now, you can just click on it whenever you need to print your excel document.

How to Print in Excel Neatly - Screenshot of the Print Button in the Quick Access Toolbar



Exercise

After you have learned how to print in excel in various ways, now is the time to do an exercise. You should do this exercise so your understanding of what you have learned will be better.

Download the exercise file below or open an excel file where you have data to be printed.

Link to the exercise file:
Download here

Now, try to print the excel file with your printer. Try to make excel not cut its columns, rows, and try to print it in a one-page version too. You can try to make other variations of printing results if you want.

What is the print result? Can you do it?



Additional Note

If you need to print multiple copies of your excel document, then it is often better to print one copy first. See if you have already got the printing result you want from your current print settings.

If yes, then you can begin to print multiple copies. If not, then you can go back to your print settings to fix the wrong things in it!



Related tutorials you should learn:



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!





Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!




Learn Excel Dashboard Course

Follow our tutorial content also on


Excel Calculation

Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division in Excel

Average in Excel



Excel Formula

VLOOKUP Function in Excel

IF Function in Excel

SUM Function in Excel

COUNTIFS Function in Excel

SUMIFS Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text in Excel

Excel Worksheet Definition

Excel Range Definition

Excel Shortcuts



Excel Products & Services Recommendation

Best Laptops for Excel

Best Tablets for Excel

Best Keyboards for Excel

Best Mouse for Excel

Best Monitors for Excel



Excel Consultation

Recommended Things

About Us

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2024 Compute Expert