Force Excel to default all documents to a "Fit to:" 1 page wide?

[djmy]

I've been asked to find a way to force all excel documents from one user to be one page wide. I've shown the user how to use the 'Fit to: 1 page wide' setting, but every now and then they forget and email the document set to print on multiple pages wide.

If I can't force excel documents to be set to one page wide, can I force excel documents to be opened with a "one page wide" setting regardless of how the original was saved?

Thanks

 

[Crystalyzer]

djmy

This is just a wild stab in the dark, but perhaps you could make the formatting change to the users Normal.xlt file so that all new excel files they create will be formatted as Fit to one page wide.



Thanks and best regards,
-Lloyd

 

[macropod]

Hi djmy,

Excel uses a file named 'book.xlt' to define the default workbook structure and a file named 'sheet.xlt' to define the default worksheet structure. The former is used for all new workbooks and the latter is used when you add a worksheet to an existing workbook. You can find where these files are stored (if they exist on your system) under Tools|Options|General.

If you create one of each with the appropriate layouts, you should be able to get the 'fit to page' feature working as required.

For existing workbooks, you'll have to make the modifications on an individual workbook and worksheet level. You could automate this with a macro.

Cheers