Excel 5 and later versions provide a tool for creating a live "snapshot" of a range and placing it anywhere you like. To use it, select a range of cells and choose Edit-Copy. Then hold down the <Shift> key and click Edit-Paste Picture Link. The result is an image of the selected range that will reflect any subsequent changes to the source. This technique is great for printing non-contiguous ranges on a single page. After creating a series of linked pictures of ranges, set them to print on one page.