I wanna make my normal style stick, but it won't !

X

Xerk

Hi,
Using Excel 2003
I'm trying to modify my Normal style so that when I type text in a cell, it
gets default-positionned in the top of the cell.
When I do it through Format /Style/ .. and modify the Normal style, it works
for the sheet I'm working on but is lost when I open a new sheet. i.e. Text
is - once again - aligned along the base line.
Like the modif is not being saved in the style or the new sheets aren't
based on the Normal style ?


In Winword my modifications to the Normal style are "carried over" into new
documents based on the normal style.
(Through the normal.dot.)
I'm expecting Excel to behave in the same way but obviously there is
something I have not understood.
Any ideas what that something might be ?

TIA
 
D

Dave Peterson

Styles live in workbooks. If you want to keep a common style, you'll have to
have a common workbook that is used as the basis for each workbook.

If you start a new workbook and modify the Normal style (and anything else you),
you can save this workbook as a template file (*.xlt).

Save it in your XLStart folder as Book.xlt.

Each time you click that New icon on the standard toolbar, excel will use that
template file to create your new workbook.
 
X

Xerk

Thanks Guys !
Did it always behave like that ?
I have a feeling that years ago, Excel files had a normal style that carried
over into new workbooks.
Wishful thinking ?
Invented memories ?
Just going gaga ???

PS
I have a colleague here named Gilles Desjardins.
Kinda spooked me that he should be giving me advice about Excel.
Then I realized I was in a NG so it couldn't be him.
Hee hee hee!

Xanks
Xerk



Gilles Desjardins said:
OR you merge your style from this sheet to the new one.

HTH

Gilles
Click to expand...
 
D

Dave Peterson

As far as I recall, excel has always had this same behavior.
Thanks Guys !
Did it always behave like that ?
I have a feeling that years ago, Excel files had a normal style that carried
over into new workbooks.
Wishful thinking ?
Invented memories ?
Just going gaga ???

PS
I have a colleague here named Gilles Desjardins.
Kinda spooked me that he should be giving me advice about Excel.
Then I realized I was in a NG so it couldn't be him.
Hee hee hee!

Xanks
Xerk
Click to expand...
 
Top