Your Excel Printing Problems, Solved

Your Excel Printing Problems, Solved

 

When you share an Excel file with others, you never know who’d like to print it. There might be times, you intentionally format your Excel sheets for printing – for example when creating handouts for your presentation.  

 

There might be times you create Excel files that you don’t intend to be printed but if you’re sharing files with others, specially your boss, make sure you format it for printing. You never know who prefers a printed version and you’ll get extra points from your boss if you make their lives easier. 

In this video we cover some important Excel printing tips: 

1. How to print an Excel sheet
2. How to fit an Excel sheet to be printed on one page 
3. Excel Printing Options on Page Layout tab 
4. How to center selection on printed page in Excel 
5. Print Excel spreadsheet with grid lines 
6. Adjusting scale for printed sheet in case printed Excel sheet is too small
7. Printing selected areas on Excel sheet 
8. Setting Excel print area to print specific areas 
9. Clear print area 
10. Add page break to Excel sheets

Related Topics:

• Excel: Dependent Drop Down Lists with OFFSET, CHOOSE, INDEX and INDIRECT 
• Get ALL External Links with This SIMPLE Excel TRICK (as NEVER seen before!) 
• How to SUM Cells by Color in Excel (Get it to update automatically) 
• Excel List Box to Display and Print Multiple Sheets as ONE Print Job with VBA