3 Simple Questions

L

Larryq22

Hello all. Can someone please tell me how to solve these simple but
irritating things?

1. How can I make a default font for footers? I have to change it from
10 point to 8 point every blasted time. Grrr...

2. How can I specify the default folder for "save as"? Right now it
seems to default to the folder from which the file came, which is
usually OK, but not when starting a new file.

3. How do I set the default zoom (and other defaults) for all new
workbooks, worksheets, etc?

Thank you,

Larry
 
P

Pete_UK

For 1 and 3, you can set up a blank sheet exactly how you would like it
in terms of fonts, column widths, headers & footers etc then do File |
Save As and pick Excel Template from the File Type panel and Book.xlt
as the filename and you want to save it in the XLStart folder. You can
do the same for a single sheet workbook and save that as Sheet.xlt in
the XLStart folder.

Now when you do File | New a new workbook will be created based on your
Book.xlt file, and if you Insert | Worksheet this will be based on your
Sheet.xlt file.

You can adjust the startup folder in Tools | Options.

Hope this helps.

Pete
 
G

George Nicholson

#1 and #3: Look in Help for "Default settings" or "Custom Start up". In XP
this would give you a list of entires with "Customize how Excel starts" at
the top of hte list. That article has a link "Save workbook settings you
want to use every time..."
What you want to do is create an empty workbook with all your desired zooms,
print footers, etc. and save it (per Help instructions) as Book.xlt in a
specific place. Then, whenever a new workbook is created, it will use that
custom Book.xlt as a template. You can also create a single-sheet Sheet.xlt
that will be used (most of the time) when you insert a new sheet. Note that
these saved settings will only apply to new books & sheets.

#2. AFAIK, the Save/Open dialog opens to the "Current" directory. Each excel
*session* uses Tools>Options>DefaultFileLocation as a starting point for
Current but from then on Current = the "last browsed to" location as a
starting point. I don't know of any way to change that other than to write
some code that would change the default directory, probably using the ChDir
statement. I'm not 100% sure of this, so if someone chimes in saying I'm
wrong, you should probably listen to them :) Even so, I don't know of any
events that are triggered when a new workbook is created, so I don't know
how you would know when to change the directory (i.e., there is no "easy"
place to put the code that would do what you want).

HTH,
 
Top