![]() ![]() ![]() 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
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |