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

  • Thread starter Thread starter Xerk
  • Start date Start date
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
 
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.
 
OR you merge your style from this sheet to the new one.

HTH

Gilles
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top