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

x
How to Split Date into Day, Month and Year in Excel

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

Delete Rows Based on Cell Value
remove rows based on values3

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
add prefix to cell113

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
insert multiple rows or columns13

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
split workbook into separate file3

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 ...

How to Get the List of File Names From a Folder
get list of file names from a folder11

This post will teach you how to get the list of file names in a given directory to a worksheet in Excel. You will learn that how to use Excel to view Files and Folders in your worksheet by get ...

Find Duplicate Values in Two Columns
find duplicate cells in two columns111

This tutorial will show you how to find duplicate values in two given columns in Excel. Or How to compare two columns and find duplicate entries in Microsoft Excel worksheet. And you will learn two methods to compare columns so ...

Remove Leading and Trailing Spaces
remove leading and trailing spaces112

In this tutorial you will learn that how to remove leading or trailing spaces from a text string in a cell in Excel. This post will guide you how to delete leading or trailing spaces of all cells in a ...

Generate Random Passwords
generate random passwords5

This post will teach you how to quickly generate a random password with Formula in Excel. You can combine a series of worksheet functions to create a complex formula to generate a random password in Microsoft Excel. Generate Random Password ...

Sort by Second or Third character in a Column
sort string by second character13

This post will guide you how to sort text string by second or third character in a Column in Excel. You may be want to sort a string in a Cell by the Second or last character in excel, how ...

Copy a Cell to Clipboard with Single Click
copy a cell to clipboard3

This post will teach you how to use the Excel VBA macro code to copy a Cell to clipboard with only single click in Excel. How do I automatically copy the content of cell to Clipboard while clicking on the ...

Sidebar