Need HELP: Change the Zoom by Default

  • Thread starter Thread starter JuliaKs
  • Start date Start date
J

JuliaKs

I need that each Workbook and each Sheet in new Workbook
will open with zoom of 120% automatically.
 
If you want new sheets to be inserted with the same zoom setting, you
can create a sheet template:

Open a new workbook.
Remove all sheets except one
Choose Save As
From the Save As Type dropdown, choose Template (*.xlt)
Name the File -- Sheet.xlt
Save it in the XLStart folder
(usually in Program Files/Microsoft Office/Office)
 
I did these stteps
The problem is that every new sheet I try create in the
files based on Book.xlt in XLStart folder open in 100%
zoom.
 
If you check Debra's instructions carefully, you'll note the name of
the file is sheet.xlt and not book.xlt. For more, you might want to
check the XL help topic 'Create a template' (w/o the quotes).

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Thanks, Debra & Tushar Mehta !
I tryed it before but it didn't work, so I thouth it is
misstake. Now I checked in TECHNET sheet.xlt keyword.
It still doesn't work in my computer but I will check it
on Monday again.
 
Back
Top