Smile please, You are on camera!
The camera or snapshot tool is amongst the most under utilized feature of Excel. You can copy a range of cells and paste a resulting snapshot picture on a worksheet. This is a neat way of easily seeing cell contents anywhere on the worksheet. You can use this method to print nonadjacent cells (on different worksheets or workbooks ) on one page. The best part is that the picture is linked and updated with both content changes and formatting changes. The camera button is made available by selecting View, Toolbar, Customize. Click on the Command tab, select category Tools and and drag the camera icon onto the worksheet, then close the dialog box.
Let us consider that the workbook has one range on sheet 1 ( RangeA ) & another on sheet 2 (RangeB). Using the camera tool we will take a picture of the RangeB and paste it on sheet 1. This picture is a special linked picture to the RangeB. It will always reflect not only the values of the Range but also the formatting applied to the cells in that range.
Here is how we do it...
If U have trouble locating the Camera tool, U could perform the following steps instead.
The result is a similar snapshot that is updated as the source cells are changed or formatted. Try it out yourself! Now it is fairly easy to take the print since the snapshot is on the same page. U could take snapshots of ranges from different worksheets (or workbooks) onto a single new worksheet which can be printed at any point in time.
Copyright 1999-2011 (c) Shyam Pillai. All rights reserved.