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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Xerk - 17 Mar 2006 11:24 GMT

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

Reply to this Message

Dave Peterson - 17 Mar 2006 12:56 GMT

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.

> Hi,
> Using Excel 2003
[quoted text clipped - 14 lines]
>
> TIA

Signature

Dave Peterson

Reply to this Message

Gilles Desjardins - 17 Mar 2006 13:09 GMT

OR you merge your style from this sheet to the new one.

HTH

Gilles

> Styles live in workbooks. If you want to keep a common style, you'll have
> to
[quoted text clipped - 32 lines]
>>
>> TIA

Reply to this Message

Xerk - 17 Mar 2006 18:25 GMT

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

> OR you merge your style from this sheet to the new one.
>
[quoted text clipped - 37 lines]
>>>
>>> TIA

Reply to this Message

Dave Peterson - 17 Mar 2006 18:42 GMT

As far as I recall, excel has always had this same behavior.

> Thanks Guys !
> Did it always behave like that ?
[quoted text clipped - 58 lines]
> >>
> >> Dave Peterson

Signature

Dave Peterson

Reply to this Message