How to change default zoom Excel 2007

[RobW]

I have a large desktop and would like to change the default zoom to 75% when
I open a new spreadsheet. I can't find where to do this.

I have Vista and am on a network. I thought the secret might be to modify
book.xls or some default template but I can't seem to find it. Any help
would sure be appreciated.

Thanks

 

[Ron de Bruin]

You can create a template named Book in your xlstart folder

Open a new workbook .
Change the things you want in this workbook (Zoom/Font/background color, font and font size and ?)
Then use File>Save As to save the file as a Template (xlt, in 2007 xltx or xltm) with the
name Book in the XLSTART folder.
Every workbook you insert now is based on this template.

You can find the Excel startup folder here
Note: this a hidden folder

C:\Documents and Settings\Ron\Application Data\Microsoft\Excel\XLSTART

Or in Vista
C:\Users\Ron\AppData\Roaming\Microsoft\Excel\XLSTART

With code you can find the correct path with this code line
MsgBox Application.StartupPath

 

[RobW]

Ron, thanks for the quick reply. When I do this and open up an existing
spreadsheet, book.xls always gets opened too. To exit Excel I have to exit
two spreadsheets. Any suggestions?

Thanks,

 

[Ron de Bruin]

book.xls always gets opened too

Read good

 

[RobW]

Thank you. I should have read that a little more closely

 

[RobW]

Ron,

I guess I have not solved the problem yet. I opened up a blank workbook,
made the zoom change to 75% and saved it as a template called book.xlt. I
have saved it to C:\Users\robwalker\AppData\Roaming\Microsoft\Excel\XLSTART
in Vista.

When I open Excel, it opens book.xlt and not book.xls. I have Excel 2007
configured to run in compatibility mode (xls). If I double-click an
existing spreadsheet, that spreadsheet opens *plus* book.xlt.

What am I doing wrong?

Thanks

 

[Dave Peterson]

I don't use xl2007 to know for sure, but it sounds like you didn't save that
book.xlt as a real template file. It sounds like you saved it as a normal
workbook with a .xlt extension.

I'd reopen excel and save book.xlt as a real template--in xl2003, you'd specify
Template (*.xlt") under the "Save as Type" box at the bottom of the File|SaveAs
dialog.

 

[Ron de Bruin]

In 2007

Office button>Save As.....
In the Save as Type combo choose

Excel Template (xltx)
Excel Macro-Enabled Template (xltm)

Or

Excel 97-2003 Template (xlt)

 

[RobW]

It seems to be OK now, thanks.

I don't use xl2007 to know for sure, but it sounds like you didn't save
that
book.xlt as a real template file. It sounds like you saved it as a normal
workbook with a .xlt extension.

I'd reopen excel and save book.xlt as a real template--in xl2003, you'd
specify
Template (*.xlt") under the "Save as Type" box at the bottom of the
File|SaveAs
dialog.

 

[Dave Peterson]

Someday, I'll join you in the xl2007 pool <vbg>.

In 2007

Office button>Save As.....
In the Save as Type combo choose

Excel Template (xltx)
Excel Macro-Enabled Template (xltm)

Or

Excel 97-2003 Template (xlt)

 

[Bob Swedroe]

I was at a complete loss. I tried saving using the old path, but I guess with Vista, that doesn't work. It would be nice if the folks at Microsoft would have this on their On-line Help; but I am sure that would be too much trouble. - Thanks again.

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com