 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2007How to change default zoom Excel 2007
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 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  SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm >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. [quoted text clipped - 4 lines] > > Thanks 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, > You can create a template named Book in your xlstart folder > [quoted text clipped - 25 lines] >> >> Thanks > book.xls always gets opened too Read good >> Then use File>Save As to save the file as a Template (xlt, in 2007 xltx or >> xltm) SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm > 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 [quoted text clipped - 31 lines] >>> >>> Thanks Thank you. I should have read that a little more closely :-) >> book.xls always gets opened too > [quoted text clipped - 38 lines] >>>> >>>> Thanks 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 >> book.xls always gets opened too > [quoted text clipped - 38 lines] >>>> >>>> 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. > Ron, > [quoted text clipped - 63 lines] > >>>> > >>>> Thanks SignatureDave Peterson 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) SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm >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 [quoted text clipped - 71 lines] >> >>>> >> >>>> Thanks Someday, I'll join you in the xl2007 pool <vbg>. > In 2007 > [quoted text clipped - 92 lines] > > > > Dave Peterson SignatureDave Peterson 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 [quoted text clipped - 83 lines] >> >>>> >> >>>> Thanks 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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.