To solve this little problem, go back to the data table by clicking on this arrow, go to the tab ‘Page Layout’ and click on ‘Print Titles’. For example, the column with the names – it’s included on page one but not on page two, which can make data reading a little bit complicated. Sometimes you might need certain rows or columns to repeat. If we now go to ‘File’ and click on ‘Print’ again, it shows the expanded print area.Īnd that’s not all for today.
Now, open the ‘Page Layout’ tab and click on ‘Print Area’ and here’s another option – ‘Add to Print Area’. We’ll select the adjacent rows 25 to 29 to expand the print area. If the originally selected and the added data are not adjacent, Excel will create a new print area. If we want to add rows, we can only do so with those which are next to the last row of the selected area, which means we can expand the current print area by adding the rows 25, 26, and so on.
#EXCEL SET PRINT AREA TO ONE PAGE HOW TO#
How to Add Cells to an Existing Print Areaīefore we get started with how to add cells to the print area, we need to remember that the last row of the current print area is 24. So, let’s go back by clicking on this arrow here in the top left corner and let’s switch to the normal view, but now we’ll do it through this button at the bottom on the right. If we now go to ‘File’ here at the top and click on ‘Print’, we see a print preview and it looks exactly as we want it to print.īut let’s move on now and have a look at a couple of more useful tricks, such as how to add more cells with data to the selected print area. Go to the tab ‘Page Layout’ and set the orientation to ‘Portrait’ or ‘Landscape’ – depends on which suits you better.
You can also change the page orientation. All dividing lines can be adjusted the same way. Drag and drop this blue line here to move the data for June to the first page. Let’s say we want to include the June figures on page one. Here the data is spread on three pages, but if this is not convenient enough, we can change that. Now if you go to the ‘View’ tab up here and click on ‘Page Break Preview’, you’ll see how the selected area is distributed on pages. Then go to the ‘Page Layout’ tab, click on ‘Print Area’ where you select the option ‘Set Print Area’. To print selected cells of an Excel spreadsheet, first you need to highlight the area. 5 How to Clear Print Area in Excel How to Change Print Area in Excel
0 kommentar(er)
