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