Excel Print Options - Set Print Area, Print Selection, Margins, and Printing Gridlines

Posted on:  07/11/2023
Excel Print Options - Set Print Area, Print Selection,  Margins, and Printing Gridlines

Excel has many print options. We will look at setting the Print Area, Print Selection, working with Margins, Printing Gridlines, and Printing Row and Column headings.

Excel Print Area

Excel Print Area

Set the Print Area in Excel

If you frequently need to print a particular section of a worksheet, for example, A1 to C40, you can establish a print area exclusively for that selection. A print area refers to one or multiple cell ranges that you can specify to be printed, allowing you to avoid printing the entire worksheet.

YouTube video

Print Selection in Excel

When you set the Print Area, Excel always prints the area until you clear the print area. If you need to print just a selection one time, you can print just the selection. Next time you print, Excel will print everything. 

Print Selection in Excel

Print Selection in Excel

Recent Articles

April 6, 2024 - Excel Training for MBA Students from the University of Georgia

April 6, 2024 - Excel Training for MBA Students from the University of Georgia

Excel - Advanced Filters

Excel - Advanced Filters

Excel - Combine Multiple Tables - Relationships (PivotTables) and XLOOKUP

Excel - Combine Multiple Tables - Relationships (PivotTables) and XLOOKUP

Excel PivotTable - Table VS. Range as source - Which is better?

Excel PivotTable - Table VS. Range as source - Which is better?

Word - How to correctly select a paragraph, sentence, word, or the entire document with the mouse

Word - How to correctly select a paragraph, sentence, word, or the entire document with the mouse

Create your own custom Watermarks in Microsoft Word

Create your own custom Watermarks in Microsoft Word

Chris Menard

Chris Menard is a certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 18 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at chrismenardtraining.com/linked or watch his videos on YouTube at chrismenardtraining.com/youtube.

Categories