If your Excel spreadsheet isn’t printing properly, clearing or setting a print area can often help. Sometimes the wrong print area has already been set, in which case you want to clear it.

Return to Excel, and print the sheet. Print Preview may show the color, but don’t worry, it should print in black and white. If your printer is far away, print to a PDF file and then open it.

2. Print Multiple Sheets or the Entire Workbook. If your Excel file contains several sheets and you want to print more than one, or even the entire workbook, Excel makes it simple to do so.

The print settings in Microsoft Excel 2010 control settings like the spreadsheet's margins, its orientation, the size of the printed sheet and whether or not the printing will be collated.

2. Determine the formulas you need for your sheet. In our example, we want to get the total number of items sold, Total Sales for each item, Grand Total Sales, and the Quota Classification.

How Do You Keep the Lines on a Sheet When You Print in Windows Excel?. Understanding how to configure the look of your company's documents is essential to conveying both style and professionalism.

Excel's print function is quite powerful, but you have to do a bit of digging to take full advantage of its capabilities. Here are just a few of the options open to you when you print with Excel.