![]() ![]() In the new sheet, press Ctrl + P to print all the copied print areas on one page.Repeat steps 1 and 2 for other print areas.On a new sheet, right click any blank cell and choose Paste Special > Linked Picture. ![]() Select the first print area and press Ctrl + C to copy it.With the help of the Paste Special feature, you can link the copied ranges to the original data in this way: If your printer has such an option, lucky you are :) If there is no such option, then the only way I can think of is copying the print ranges to a new sheet. To check if this option is available to you, press Ctrl + P, click the Printer Properties link, and then switch through the available tabs of the Printer Properties dialog box searching for the Pages per Sheet option. The ability to print multiple areas per sheet of paper is controlled by a printer model, not by Excel. Under Settings, click the arrow next to Print Active Sheets and select Ignore Print Area.When you want a hard copy of a whole sheet or entire workbook but do not want to bother clearing all the print areas, just tell Excel to ignore them: Adjacent ranges, even selected separately, will be included in a single print area. This only works for non-contiguous ranges. To select multiple ranges, please remember to hold the Ctrl key. On the Sheet tab, put the cursor in the Print area field, and select one or more ranges in your worksheet.This will open the Page Setup dialog box. On the Page Layout tab, in the Page Setup group, click the dialog launcher.Want to visually see all your settings? Here's a more transparent approach to defining a print area: More informative way to define print area in Excel On the Page Layout tab, in the Page Setup group, click Print Area > Set Print Area.Ī faint gray line will appear denoting the print area.Select the part of the worksheet that you want to print.The quickest way to set a constant print range is this: To instruct Excel which section of your data should appear in a printed copy, proceed in one of the following ways. Without it, you may end up with messy, hard to read pages where some important rows and columns are cut off, especially if your worksheet is bigger than the paper you are using. If you change your mind at a later point, you can clear the print area or change it.ĭefining a print area gives you more control over what each printed page looks like and, ideally, you should always set a print area before sending a worksheet to the printer. Saving the workbook also saves the print area. You can select multiple print areas in a single worksheet, and each area will print on a separate page. When you press Ctrl + P or click the Print button on a sheet that has a defined print area, only that area will be printed. In case you don't want to print the entire spreadsheet, set a print area that includes only your selection. Then, hold down CONTROL and click the tabs of the other sheets that you want to select.A print area is a range of cells to be included in the final printout. Next to Print What, click the option that corresponds to what you want to print ( Selection, Active Sheets, or Entire Workbook) and then click Print.Ĭlick the tab for the first sheet. On the Printer pop-up menu, select the printer that you want. The Page Layout tab in the ribbon includes more options for page setup and printing, including page orientation, paper size and whether to print gridlines and headings. Select Show Details in the Print dialog box to print to a PDF file, or to set which pages to print, paper handling options, margins, and scaling. In the Print drop-down menu, select Selection, and then select Print. Or, for nonadjacent files, hold down COMMAND and select the name of each workbook that you want to print.Ĭlick a cell within the table to activate the table. Note: All of the workbook files that you want to print must be in the same folder.įor adjacent files, hold down SHIFT and select the name of each workbook that you want to print. Hold down CONTROL and click a sheet tab, and then click Select All Sheets on the shortcut menu. Then, hold down COMMAND and click the tabs of the other sheets that you want to select. Then, hold down SHIFT and click the tab for the last sheet that you want to select.Ĭlick the tab for the first sheet. Select the sheets that you want to print.Ĭlick the tab for the first sheet. In the Print drop-down menu, select the option that corresponds to what you want to print ( Selection, Active Sheets, or Entire Workbook) and then select Print. To change what is printed, select Show Details. The default is to print all active sheets. On the Printer menu, select the printer that you want. To print a workbook, click any of its sheets. ![]() To print the entire sheet, click the sheet or the sheet tab. To print a partial sheet, click the sheet, and then select the range of data that you want to print. ![]() Print a partial sheet, an entire sheet, or an entire workbook ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |