Printing non-contiguous areas on one page
Insert a new worksheet (you're going to use this only for printing). Do this for each area you want to print on the same page, the areas don’t have to be on the same sheet. If you change the original range, the picture will change to (values and formatting!). You can always use this sheet to print because it will always update if you change the original data.
- Select the range
- Use Cmd-C to copy the range
- Go to the new worksheet you will use for printing
- Right click on the destination cell and choose Paste Special > Paste Picture Link