Select multiple ranges by holding the Ctrl key and clicking on the cells.Go to the Sheet tab, and put the cursor in the Print area field.Click the dialog launcher in the Page Setup group.Open the Excel sheet and switch to the Page Layout tab.Here’s the procedure to setup multiple ranges to print in Excel: There’s an even better solution available for you. You’ll set multiple areas for print in a moment.īut, as you are working with thousands of data cells, this method might not be suitable for you. Then, move to the Page Layout tab and navigate to Print area > Print area. Press and hold the Ctrl key and select the cells you want to print out. The quickest method to set multiple print areas is using a keyboard and mouse. How to Set Multiple Print Areas in Microsoft Excel Here’s a complete guide on how to Lock and Unlock Cells in Excel. But you don’t know how to set up multiple print areas from a sheet? No worries, check out the following section. Usually, verifying is necessary when you’re setting multiple cells to merge for printing. Switch back to normal mode once you make sure the selected cells are correct. You’ll notice the selected print area in a box. Go to the View tab on your Excel sheet.Here are the steps to view a print area in Excel: Though page break can be used for other purposes, you can use it to view Excel print areas.Ĭheck out our separate post on how to MS Excel Lock a Cell. For that, Excel offers a feature named Page break preview. Once you set up the print area, you might want to review whether the selected cells are correct or not. Now, you can print a copy with those specific cells. You’ll notice only the selected print area is available on the Print preview page. Click Print Area in the Page Setup group.Move to the Page Layout tab from the ribbon.Select the range of cells that you want to print.Here are the steps to set a specific print area in Microsoft Excel: Sounds fair, right? Let’s see how you can do that. So, what you can do is, Select the cells that contain the August 2022 report and only print that data. And not even the sales report for every month of the year 2022. One day, your manager asks for the August 2022 sales report.Ĭlearly, you don’t want to print the entire sales report of the company (from 1992-2022). You’re currently working on the entire sales report that is recorded in an Excel sheet. Let’s say you are an accountant of a multinational company. Set a Print Area in Excel with Easy StepsĪ print area is the range of cells you want for the final printout. How to Set Multiple Print Areas in Microsoft Excel.Set a Print Area in Excel with Easy Steps.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |