Under Settings, specify exactly what to print and configure the page margins, orientation, paper size, etc.Ĭhoose what to print: selection, sheet or entire workbook.

Under Printer, choose which printer to use.

In the Copies box, enter the number of copies you want to get.

This will get you to the Print Preview window.

In your worksheet, click File > Print or press Ctrl + P.

To print an Excel worksheet, this is what you need to do: And then, we will have a closer look at the most important and useful features.

Print to file to save output for later useįor starters, we will provide high-level instructions on how to print in Excel.

Print the same range in multiple sheets.

Print selection, whole sheet or entire workbook.Our tips will work for all versions of Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010 and lower. This tutorial aims to help you get perfect hard copies of your Excel documents. This is because Excel worksheets are designed for comfortable viewing and editing on screen, not to fit on a sheet of paper. Just click the Print button, right? In reality, a well-organized and beautifully formatted sheet that looks great on a monitor is often a mess on a printed page. At first sight, printing Excel spreadsheets is super easy. Living in a digital world, we still need a printed copy every now and then.

Learn how to print Excel spreadsheets exactly the way you want - print selection, sheet or entire workbook, on one page or multiple pages, with proper page breaks, gridlines, titles, and a lot more.

Excel 2013 print preview