I have a number of spreadsheets this happens to, what happens is when I
click on the print button in Excel it prints say 5 sheets instead of 1
(where the data is) the rest of the pages are blank. How can I stop this
from happening without having to keep selecting one of one pages on the
print options?

It might help to select the range of cells to be printed and use:
File Print area Set print area