How to change print area in excel 2007 driver#
How to change print area in excel 2007 plus#

I have a macro to adjust various rows' heights based on a reference cell value. The workbook is very important as it tracks the use and movements of hundreds of explosives as used in the oil and gas industry. I am creating a workbook that captures data on a few different worksheets and combines it all into one review sheet. You can also print the worksheet containing the camera pictures, and they will appear on a single page.I have searched TechNet and other forums for an answer to this but have had no joy. Instead, it is dynamic, meaning that if the contents of the original ranges are changed, then what is shown in the picture changes, as well. The picture is not really a picture, however, even though it behaves as one. Now you can manipulate the two pictures the same as you would any other graphic-stretch, resize, crop, or move them whatever. Repeat steps 1 through 4, but select the other range you want printed (E3:G5).The picture is inserted as a graphic on the worksheet. Click where you want the top left-hand corner of the picture to appear.Change to a different worksheet, preferably a blank one.

How to change print area in excel 2007 plus#

The mouse pointer changes to a large plus sign. For instance, select A1:C5, the first part of the area you want to print.

Select the range that you want to take a picture of.

Close the Customize dialog box, and you are ready to use the Camera tool. (Oddly enough, it has a small camera icon to the left of the command.) Drag the Camera command to a toolbar and drop it there. In the list of Categories, choose Tools, and then scroll through the Commands list until you find Camera. Choose Tools | Customize and make sure the Commands tab is displayed. Instead, you need to add it to the toolbar. The Camera tool is not available, by default, on any Excel toolbar. This tool allows you to capture dynamic 'pictures' of different areas of your worksheet. You can then print the consolidation worksheet, as it will contain only the information you want sent to the printer.ДЄ third option involves using the Camera tool. This sheet can contain references to the original data ranges, combining them on a single worksheet. The next solution involves simply creating a 'print' worksheet. In that case you won't be able to use this workaround and will have to try the next one.

How to change print area in excel 2007 driver#

If you cannot find a control that allows you to specify multiple pages per sheet (step 5), it may be that your printer driver doesn't offer this capability. It does this by reducing the size of each of the two pages and printing them in landscape mode on the page. The result, for most printers, is that Excel combines two printed pages on a single sheet of paper. Click OK to close the Properties dialog box.Set this control so that 2 pages are printed per sheet of paper. You are searching for one that allows you to set multiple pages per sheet of paper. Browse through the available tabs and controls.Excel displays the Properties dialog box for the selected printer. Make sure the destination printer is properly selected at the top of the dialog box.Set your two ranges as your print area, as you have already done.

There are a couple of things you can try as workarounds, however.ДЇirst, you could print multiple pages per sheet of paper. This happens because Excel automatically prints separate ranges on separate sheets of paper there is no way to configure Excel to do this printing differently.

Ingrid was hoping to get them on a single sheet of paper. When Ingrid printed the worksheet, each of the selected ranges (A1:C5 and E3:G5) printed, but they printed on separate sheets of paper. This selection was then defined as the print area (File | Print Area | Set Print Area). She first selected A1:C5, then held down the Ctrl key as she selected E3:G5. Ingrid set up her worksheet just the way she wanted, and then defined two non-contiguous areas on the worksheet as her print area.