I am not sure I understand what you mean, the workbook will always have
approx 1mb of rows and 16k of columns,
You can clear used ranges so it doesn't print extra pages using this method

http://www.contextures.com/xlfaqApp.html#Unused

works for all excel versions

The only other way to mimic as if there is only this particular size would
be to hide all rows and columns that are not used


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com



ippin" wrote in message
...
An error with IE when I tried to post (hopefully this will not be a double
post)

I have created a sheet in Excel 2007 (beta) I would like to save the sheet
without the extra cells/rows etc I deleted pages 2&3 but can't remove the
extra sheet information when I only need to print and keep a compact sheet
of
the data.
I have tried to copy etc but I am always presented with the full sheet -
is
it possible to remove the excess on sheet 1 and only save and print the
comapct sheet?