Discussion Locked

Excel XP

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
The dafault zoom view on the standard toolbar is 100% for Excel. How do I change that to default to 115%?

7 replies

by dklippert

Open the file Book.XLT
Change the zoom. Close the book. Close Excel and reopen.
If you can't find Book.XLT create one.
Remember to save as and XLT file

by lf king

I tried this, but do you have to open excel with this book each time? I want excel to open with this percentage. Like word does with the normal.dot

by dklippert

Book.XLT is "kind of" like Normal.dot. Whenever you open a new Workbook, it is the template that will be used.

by lf king

Where do you store the book.xlt? I searched the c drive and could not locate an existing one, so I'm assuming that there is a specific place that I'm not aware of.

by dklippert

When you choose File>Save As,
At the bottom of the dialog box is a drop down list called "Save as type:"
Choose Template(*.XLT)
The location will then change to Templates.
You want to navigate to the XLStart folder
usually
C:\Program Files\Microsoft Office\Office10\XLStart

by lf king

This works, I only have a few XP setups and the rest of 97, new things to learn.

This discussion is closed to new replies.