Excel Print Options - Set Print Area, Print Selection, Margins, and Printing Gridlines
Posted on: 07/11/2023
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
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
Recent Articles
Nov 4, 2025 - Executive Insights: Harnessing Excel for Strategic Analysis
Nov 4, 2025 - Join us on November 4, 2025, for a live, in-person training: Executive Insights – Harnessing Excel for Strategic Analysis. Learn how to master Power Query, PivotTables, data cleaning, sorting and filtering, conditional formatting, and charts to create impactful reports and support leadership with confidence. Perfect for Executive Administrative Professionals looking to boost efficiency and deliver data-driven insights.
Chris Menard
Chris Menard is a Microsoft Certified Trainer (MCT) and Microsoft Most Valuable Professional (MVP). Chris works as a Senior Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel featuring over 900 technology videos that cover various apps, including Excel, Word, PowerPoint, Zoom, Teams, Coilot, and Outlook. To date, the channel has had over 25 million views.
Menard also participates in 2 to 3 public speaking events annually, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.
Categories