Print area

[Dinah Jones]

I have seen a workbook where people have set it up for more then one page
area.

These print areas are then visible from a dropdown box on the left side.

Has anyone any idea how to set up these multiple print areas.

Dinah

 

[MartinW]

Hi Dinah,

Try this on a blank sheet just to get the hang of it.
Go to View>Page Break Preview
Select a small block of cells
Right click on the selection and choose Set Print area
Now select another block of cells
Right click on the selection and this time choose Add to Print area
Do this three or four times on little sections of your sheet
Now go back to View>Normal
The dotted page break lines will show the areas that you selected.
You can go to Tools>Options>View Tab and uncheck page breaks
to get rid of these lines.
Now click on the Name Box dropdown just to the left of the formula bar
and select print area, The areas you set should now be highlighted.

You should be able to adapt it to your needs from there.

HTH
Martin