If you need to print your work in Excel, this tip would save you some papers. Using this, you can set the print area in Excel worksheets, so that only that part of the worksheet is printed.
This technique could be useful if you want to print only a part of a report or there is a section of the report that you need to print often
A print area is a range of cells (contiguous or non-contiguous) that you designate to print whenever you print that worksheet. For example, instead of printing the entire worksheet, if I only want to print the first 10 rows, I can set the first 10 rows as the print area.
In this video, you’ll learn:
— How to Set the Print Area in Excel Worksheets.
— How to Modify the Print Area in Excel.
— How to Clear the Print Area in Excel.
Click the link below to Subscribe to the Channel:
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos –
This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.
You can find a lot of useful Excel resources on the following site: