Excel shortcuts

How to Set the Print Area in Excel with a Shortcut

If you regularly print your Excel worksheets, you know how frustrating it is to have to constantly adjust the print area to include all the data you need. Fortunately, there's a shortcut you can use to quickly set the print area in Excel.

To set the print area in Excel, first select the cells you want to print. Then, click the Page Layout tab on the ribbon. In the Page Setup group, click Print Area and then click Set Print Area.

You can also use the keyboard shortcut Alt+P+R to quickly set the print area in Excel.

Once you've set the print area, all you need to do to print your worksheet is click the File tab, click Print, and then click Print.

If you ever need to adjust the print area, simply select the cells you want to include in the print area and then click the Page Layout tab on the ribbon. In the Page Setup group, click Print Area and then click Set Print Area.

You can also use the keyboard shortcut Alt+P+R to quickly set the print area in Excel.

Once you've set the print area, all you need to do to print your worksheet is click the File tab, click Print, and then click Print.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.