Sometimes we may need to print couple of areas located in separate ranges of our worksheet or on different worksheets in our workbook. The reason? This way we could simply save couple of paper sheets. Also, such combining of separate ranges on one page might be useful, or even necessary, for comparison / presentation purposes, etc.
So, how could we do that?
The easiest way, I'm using, is to employ the Excel Camera tool. The tool might not be available by default on your Quick Access Excel toolbar (top-left corner). If so, you can add it there by choosing Toolbar>Customize>More Commands... Scroll through the list of Commands to find Camera and drag it to the toolbar. From now on it'll be always ready for you to use.
Here's how to use it, e.g. for printing:
