Additionally, setting a print area is useful for larger spreadsheets with a lot of data that would otherwise overflow onto additional pages. ![]() By following these steps, you can set a print area of your choice and have a printout that exactly fits your preferences. Setting a print area is a more efficient way of printing an Excel worksheet than printing the entire workbook. Ensure that you have set the printer settings and paper size correctly before printing. To do this, navigate to the “View” tab and then click on the “Print Layout” view.įinally, navigate back to the “Page Layout” tab and click on the “Print” button to start printing the document. It looks like one has to highlight the print area and then go to Page Layout / Print Area / Set Print Area. In Excel of Office 365 the Print Area in the Page Setup/ Sheet / Print Area is grayed out. It is always essential to view the document’s print preview before printing to ensure that everything is laid out correctly. In earlier versions of Excel, one could set the print area via Page Setup/ Sheet / Print Area and one could put in a string like 'A1:K63'. Within this dialog box, you can make changes such as adding or removing cells from the print area. In the Tall box, enter 0 so that the number of pages tall is unspecified. In the Page wide by box, enter 1 (for one-page wide). On the Page tab, select the Fit To check box. You may also use the keyboard shortcut “Ctrl+Shift+P” to bring up the Print Area dialog box. On the Page Layout tab, select Page Setup. This will reveal a few options, one of which is “Set Print Area.” Clicking on this will make the selected cells the print area. In the “Page Layout” tab, navigate to the “Page Setup” section, and click on the “Print Area” drop-down arrow. Alternatively, if you have a named range, you can select it by clicking the drop-down arrow next to the Name Box in the top left corner of Excel.Ĭlick on “Page Layout” tab to view the options available in that tab. Then, go to the Page Layout tab and click the Print Area drop-down arrow in the ribbon. You can do this by clicking and dragging your cursor over the cells, or you can press “Ctrl + A” to select all cells in the sheet. To set a single print area, select the cells. Select the cells that you want to include in your printout. Open the Excel workbook that you want to set a print area. In this article, we will discuss how to set a print area in Excel. Fortunately, you can easily limit what gets printed using the print area feature. However, it can be frustrating when you have a large amount of data, and your printout includes pages of unnecessary information. ![]() One key feature in Excel is the ability to print spreadsheets. Step 2: Use your mouse or trackpad to highlight the section of the spreadsheet that you want to set as the print area.Microsoft Excel is widely used across various fields and professions for organizing and analyzing data. Try this: Sub SetPrintArea () Dim ws As Worksheet Dim lastRow As Long Set ws ThisWorkbook.Sheets ('Tags') find the last row with formatting, to be included in print range lastRow ws.UsedRange.SpecialCells (xlCellTypeLastCell).Row ws.PageSetup. Step 1: Open the spreadsheet in Excel 2011. Its easier to see what is happening if you declare a few variables and decompose your statement. Note that this is something that you will need to set and clear if you decide that you want to print the entire spreadsheet, or a different part of the spreadsheet later. How to Define the Print Area in Excel for Mac (Guide with Pictures) We have previously written about how to fit that sheet to one page in Excel 2011, but that isn’t always practical when you are dealing with a lot of data.īut you can take advantage of a feature that allows you to set a print area in Excel 2011 so that only part of a spreadsheet is printed, as opposed to the entire thing. installed, and thats why excels set print area function wont work. Occasionally you may find yourself working with a very large spreadsheet that you need to print. Our guide continues below with additional information on how to set a print area in the Excel Mac application, including pictures of these steps. Choose Print Area, then Set Print Area.Select the cells to include in the print area. ![]() 2 How to Define the Print Area in Excel for Mac (Guide with Pictures) How Do You Set an Excel Mac Print Area?
0 Comments
Leave a Reply. |