How do you change default cell alignment in Excel 2003

By jim_vander_noot ·
The default of "bottom" for vertical cell alignment in Excel drives me nuts. I've tried everything I can think of to change it - formating a workbook and saving it as a template, etc, etc...

Nothing works - everytime I open a new workbook, I have to select the whole sheet and go into the format menu.

I'm sick and tired of this. HELP!!!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Changing Default Excel Cell Alignment

by schiefed In reply to How do you change default ...

Try Format->Style..., Modify...
Select your desired alignment.

Help provides additional insight

Collapse -

excel text alignment-default settings

by hkrishnan In reply to Changing Default Excel Ce ...

Thanks for crisp and correct answer which solved my 6months of frustration with excel standard formatting of cells.

Collapse -

Create a Template

You were right, you need to create a template. The hardest part is to figure out where to save it so it becomes your default template.

Configure a excel file the way you want, and save it as a template called BOOK.XLT, but not in the default template directory that pops up - instead save to the following location:

C:\Program Files\Microsoft Office\OfficeXX\XLSTART\

(OfficeXX will be dependent on which version of MS Office you have, but you're looking for the one that has a folder called XLSTART in it)

Once you've save it here, close Excel, and next time you open Excel, it should open a new workbook called "Book1" with your new default formatted settings. When you save the new file, it'll give you your default "save as" box as normal. The only difference between this and what you have now is whatever you've added to the default template.

If you ever get tired of how your formatted, just delete the BOOK.XLT file and start over with the new way you'd like it formatted.

Collapse -

Default Vertical Alignment in Excel

by rimrunner In reply to Create a Template

This tip has solved one of my greatest issues with Excel which has bugged me for years...thanks heaps!!

Collapse -

Additional grief

by a_godo In reply to Default Vertical Alignmen ...

I've been searching for this half heartedly for years. I've run into the xlt solution before, but was frustrated. It was never saving the xlt file to the main location, but to my local documents. Just another level of frustration! After saving the book.xlt, if it is not in c:\program files\microsoft office\officexx\xlstart, try the drop down to see where it actually saved it, or go to your C:\Documents and Settings\you.dude\Application Data\Microsoft\Templates folder and there it lies prolly with a bevy of other obscurely named files.

Collapse -

I'll second that!

by techrepublic In reply to Default Vertical Alignmen ...

I know it's trivial, but this had bugged me for years; thanks for the post! (BTW the suggestion to modify the Style doesn't persist to the next new workbook, let alone the next execution of Excel! This one works!)

Related Discussions

Related Forums