Excel 2007 - Format of New Documents

  • Thread starter Thread starter dza7
  • Start date Start date
D

dza7

Hello,

I'd like to make so that whenever I create a new document in Excel
that the "Page Setup" is set to scale of "fits to 1 page wide by 1
page tall".

I'm sick of creating a new document and always having to go to Page
Setup so that everything prints on one page. Don't you think this
should be a default setup for any new documents?

Thanks in advance,

Dza
 
dza7 said:
Hello,

I'd like to make so that whenever I create a new document in Excel
that the "Page Setup" is set to scale of "fits to 1 page wide by 1
page tall".

I'm sick of creating a new document and always having to go to Page
Setup so that everything prints on one page. Don't you think this
should be a default setup for any new documents?
Click to expand...

You can put VBA code in, say, the Workbook_NewSheet event to set the
parameters for PageSetup:
 
Create a custom template. Open a blank workbook, make whatever
changes you want your default workbook to look like. It could be
printing, styles, fonts, etc. Click Save As, select 'Save as type' as
Template (this will place the template in the correct location
automatically), type the name as Book.XLT. Voila.

Regards

Paul Martin
Melbourne, Australia
 
Two ways of doing this already offered. If the 1x1 setup fits your needs
better than 90% of the time, I'd create the template file as Paul Martin
suggested.

As for what the default setup "should be" - that's a personal issue for each
user to determine. I would hazard a risky guess that most people's use
either exceeds a comfortable width or height for a single sheet of paper.
Only if you have a relatively small number of not very wide columns and fewer
than say 40 or 50 rows of data does a 1x1 come out usable. Try that with a
sheet with even just 2 columns of data, but with a couple of thousand rows in
use.

That's the beauty of creating .xlt template files: you can have various
setups for multiple needs, and one for your typical requirements.
 
Back
Top