Excel Print

Contents:
Print a worksheet | Print a workbook | Print a selection rangeCollated/Uncollated printPrint orientationPage Margin setting | Print Scaling | Quick print

How do I print a worksheet in excel? How do I print a workbook in Microsoft Excel 2013? How to quick print a excel work sheet? How to print a selection excel range? How to change the print setting to print the excel file base on your request. This post will guide you how to print a excel file.

Print a worksheet

If you want to print a worksheet, just refer to the following steps:

1# click “File” Tab

excel print file tab

2# click “Print” menu, then click “print” button in the upper right corner.

excel print page

Then the current worksheet should be print base on the default page setting.

Print entire workbook

If you want to print a workbook that contains two or more worksheets, just execute the following steps:

1# click “File” tab in the current workbook

2# click “print” menu

3# select “Print Entire Workbook” from print setting drop-down list.

excel print workbook

Note: excel just print the current worksheet by default. You can see that the default setting is “Print Active Sheets”. It means only print the active sheets.

Print a selection range

To only print the current selection range, just execute the following steps:

1# select cell ranges that you want to print in the current worksheet.

excel print select range

2# click “File” tab in the current workbook.

3# click “print” menu.

4# select “Print Selection” from print setting drop-down list.

excel print selection

Collated/Uncollated print

When you print multiple copies for one file that contain multiple pages, you can control the print order as Collated or Uncollated. For example: 3 page files, print 3 copies for each file.

If you choose “Collated”, then it will print the first copy (page 1, page2, page3), then print the second copy…etc.

If you choose “Uncollated”, it will print 3 copies of page1, then 3 copies of page 2…etc.

How to set the print order “Collated” or “Uncollated” in excel? Just execute the below steps:

1# click “File” tab in the current workbook

2# click “print” menu

3# select “Collated” or “Uncollated” from Collated setting drop-down list.

excel print collated uncollated

Print orientation

There are two orientation in excel print as: “Portrait Orientation” and “Landscape Orientation”.  How to switch those two Orientation in excel? You just need to change it in print setting.

excel print orentation landscape portrait

Page Margin setting

While you print a excel file, you may need to adjust the page margins for you special request.  There are three predefined margins (Normal, Wide and Narrow) modes that you can select. Also you can custom page margin via the following steps:

1# Go to print setting page, then click “Margin” setting drop-down list.

excel print margin drop list

2# Click “Custom Margins…”, then “Page Setup” window will appear.

3# click “Margins” tab, then you can set the page margin value, such as: Top, Left, Bottom, Right…etc.

excel print margin page setup

Note: you can also drag the margin lines to change the page margins, just need to click “Show Margins” at the right bottom of print setting window.

excel print show margins icon

Print Scaling

If your worksheet has lots of rows or columns, you can print all your data (rows and columns) on one page, then you can use Scale to shrink all data to fit the printed page. There are 4 scaling choices in excel print setting.

  • No Scaling (print sheets at their actual size)
  • Fit Sheet on One Page (print all data on just one page)
  • Fit All Columns on One Page (shrink the printout so that it fits on one page)
  • Fit All Rows on One Page (shrink the printout so that it is on one page high)

Just go to print setting to set scaling setting via “File”->”Print”->”setting

print scaling

Quick print

If you want to print the worksheet quickly without any print setting, you can just click “quick print” under quick access toolbar. After clicking “quick print”, the current worksheet will be print right now.

excel quick print

Note: you can also press “Ctrl +P”, then click “Print” button to quick print the worksheet.

Related Posts

How to Convert Ounces to Pounds or Grams in Excel

This post will guide you how to convert ounces to pounds or grams with formula in Excel. How do I convert pounds to ounces or grams in Excel 2013/2016. Convert Ounces to Pounds Assuming that you have a list of ...

Delete Rows Based on Cell Value

This post will guide you how to use the Find & Replace feature to delete or remove all rows based on certain cell value in Microsoft Excel. Or how to delete all rows that contain certain value with VBA code ...

How to Add Prefix or suffix to Cell

This post will guide you how to add common prefix or suffix to all cells or the range of cells in your worksheet in Excel. How do I add the same prefix or suffix to a range of cells without ...

Quickly Insert Multiple Rows or Columns in Excel

This post will guide you how to quickly insert multiple rows or columns in your Microsoft worksheet. You will see that how to add new multiple rows or columns with shortcut or insert feature, or insert copied cells in excel. ...

Split Excel workbook into separate Files

This post will guide you how to split a large workbook to separate files and each worksheet should be saved as a single file. How do I split the whole workbook into several excel worksheets or single excel file. Assuming ...

Sidebar