Check your 'Print Area' settings in the Excel 2007 version - it is on the
Page Layout ribbon. I'm thinking that it's set to an area that includes a
lot of empty cells (to the left of your table?) and just a column or two of
the table itself.

Might be easier to diagnose if we knew the layout of your sheets - what
column the tables start in might give us a better clue.

"Paul" wrote:

Hello, I have in issue printing an excel file. The file is a 2007 format
and consists of several tables on several sheets. When I try to print a
sheet the printer will just print 3 blank pages with a couple characters on
each. I have saved the file as a 2003 version and the same thing happens.
If I copy a range of cells then past into a new sheet they print although
they have lost formatting. What could be going on here and how can I fix it?
Thank you