- #How to change print area in excel 2016 how to#
- #How to change print area in excel 2016 software#
- #How to change print area in excel 2016 free#
We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships. Printing Microsoft Excel spreadsheets can be tricky, but you can avoid most printing problems by following these tips. Learn more.How to Print from Microsoft Excel & Avoid Printing Problems
![how to change print area in excel 2016 how to change print area in excel 2016](https://howtech.tv/wp-content/images/005152/5.jpg)
This doesn't affect our editorial independence. Note: We may earn a commission when you buy through links on our site, at no extra cost to you.
#How to change print area in excel 2016 how to#
If you want more tips on how to get the best out of Excel, then be sure to read our Best Excel Tips guide. A few ways to apply print areas across your whole workbook.
![how to change print area in excel 2016 how to change print area in excel 2016](https://us-static.z-dn.net/files/d28/b432f89d9422d8d3b16c5f7f7d7934a0.png)
SPrintArea = įor Each wks In ActiveWindow.SelectedSheets Once you’re ready, create the macro outlined below, and you should soon have your print areas appearing in all sheets of your workbook.
![how to change print area in excel 2016 how to change print area in excel 2016](https://www.dummies.com/wp-content/uploads/221939.image0.jpg)
If you’ve not used macros before, then check out our How to use macros in Excel guide to get yourself up to speed. This macro will apply the print area on the current active sheet (the one that is displayed on your screen) to any other sheets in your workbook. Lastly, if you’re happy to try your hand at macros, then there are many helpful variants available online.Ī very good one we came across was created by author Allen Wyatt, and is outlined on his Excel Tips blog.
#How to change print area in excel 2016 free#
Kutools has a free thirty-day trial, but if you want to carry on using it you’ll need to purchase a copy, which currently costs around £30 (US$39). The best part of this is that you can skip over ones that you don’t want to print, so it isn’t an all-or-nothing approach. The first is to use a third-party solution such as Kutools for Excel, which has a Copy Page Setup feature that allows you to apply a print area to multiple pages across a workbook. Simply copy the sheet and the print area will come with it to the next one.įor those who already have a lot of data in existing worksheets there are other options available. Lay out the page, create the print area, and then use this as a template for every sheet you add. If you’re only just beginning a workbook, and intend to use a print area that will be the same on every sheet, then there is a better solution. Obviously, this can get a bit laborious especially if you have a large workbook.
#How to change print area in excel 2016 software#
The most obvious solution to this is simply to go through each one and manually set the print areas, which the software is happy to let you do. Sadly, Excel doesn’t have an automated way to replicate print areas on multiple sheets. How can I create a print area on all sheets? Note that these will all be printed as separate pages. To clear this, simply go back to the Page Layout tab, select Print Area, then click on the Clear Print Area option.Ī worksheet can have multiple print areas, all created using the method outlined above. Now when you go to print off this page it will only use the data in the print area. In the Page Setup area you’ll see an option for Print Area. Next, click on the Page Layout tab at the top of the menu ribbon.
![how to change print area in excel 2016 how to change print area in excel 2016](https://img.youtube.com/vi/vEti0pPtA2w/hqdefault.jpg)
Open a worksheet in Excel, then highlight the cells you want to include. It’s handy if you tend to have a mixture of figures on your sheet, but only need particular ones for certain reports. In Excel, print areas allow you to select cells on a worksheet which can then be printed off separate to the rest of the page. But what if you want to print the same area on every page of your spreadsheet? We show you a few ways to make this happen. This can be done by highlighting the cells you want before hitting Ctrl+P. Sometimes you don’t want to print off an entire spreadsheet to bring to a meeting, but rather just the salient figures that show something about a particular subject.