How to set default cell formattiing to vertical alignment = top ??

[akm]

How to set 'Alignment', 'Vertical:' cell formatting to be 'Top' as default
format for all new worksheets ?

 

[JE McGimpsey]

Take a look at "default workbook" in XL Help.

 

[akm]

JE
Thanks for the reply, but dont find anything for a 'vertical alignment'
default setting.
Most 'help' sections refer to 'options', but cant find any such setting in
'options'.
What am I missing ?

 

[Pete_UK]

Basically, you create a template and save it as Book.xlt in your
XLSTART folder. You can also save a single sheet as SHEET.xlt.

In these templates you set things up exactly as you want them to
appear in a blank workbook or for a newly-inserted worksheet,
including things like headers and footers, formatting of cells, font
size and type etc.

Hope this helps.

Pete

JE
Thanks for the reply,  but dont find anything for a 'vertical alignment'
default setting.
Most 'help' sections refer to 'options', but cant find any such setting in
'options'.
What am I missing ?

 

[akm]

Pete
Thanks very much for the info.

I put a file (eg with special column widths) called Book.xlt in the XLstart
folder at C:\Program Files\Microsoft Office\Office\XLStart.

Doesnt appear that Excel opens that workbook (as a default) each time a new
workbook is started ?

That would seem like a good way to work around the fact that Excel doesnt
offer the setting in 'options' etc, but how do I get that to happen (ie
create a template that will be that default workbook used by Excel when
starting/opening a new workbook (Book.xls) file ?

Is there a way to do that ?

Thanks again for your help.
akm

Basically, you create a template and save it as Book.xlt in your
XLSTART folder. You can also save a single sheet as SHEET.xlt.

In these templates you set things up exactly as you want them to
appear in a blank workbook or for a newly-inserted worksheet,
including things like headers and footers, formatting of cells, font
size and type etc.

Hope this helps.

Pete

 

[Gord Dibben]

Did you save the workbook as a Template(*.xlt) or just name it Book.xlt?

If properly done........................

If you clicked on File>New...Blank workbook, you will get the Excel default
workbook.

File>New or click on New File Icon to get your revised workbook.

For location of XLSTART folder....................

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

Gord would be your username.


Gord Dibben MS Excel MVP

 

[akm]

Gord
Thanks for the reply.

Appears Ive done what you describe...
1. Saved a new workbook (with special column widths as a test case) as a
Template(*.xlt), named it Book1.xlt, in C:\Documents and
Settings\akm\Application Data\Microsoft\Excel\XLSTART
2. Closed Excel
3. Opened Excel and clicked on new workbook icon
4. New workbook did not open as test case template file

What am I missing ?

 

[Gord Dibben]

You must name it "Book"(no quotes) and let Excel add the .xlt part

Do not name it Book1

See from Pete's original post......

Gord

 

[akm]

Gord
That seems to have done it, thanks for sticking with me on this one !
Not much of a geek, so dont know how to return the favor, but if there was a
way Id try.

 

[Gord Dibben]

Around here we return favors by one day helping someone else, which I'm sure you
will have opportunity to do.

As we used to say up North...........Don't pay me. Just don't pass by the next
car you see in the ditch.


Gord