Printing in Excel

Manually, you could define the first print range, and print, then define the second print range and print. This could also be made into a macro and have it done automatically. A second way would to be, copying the print ranges to a different part ofthe spreadsheet and then printing from there.

Unfortunately, Excel does not have a way to print cells that are on different worksheets on the same printout.
Here are a few ways to do it:
Make a consolidated sheet that will refer to sheets A and B.
(=A!A1, =B!A1, etc.);

Copy the cells and paste into a third sheet;

Use the Camera icon in the Tools>Customize dialog box. Look unat the bottom of the Commands list Tools. With the camera, you can place a dynamic ?snapshots? of each sheet and place them on a third sheet.

This question was auto closed due to inactivity