changing the default cell format

M

Moomoo

How can I change the default cell alignment to be centered
vertically, instead of the defaulted bottom vertically?
 
I

Ian Coates

You can create a template with your required formatting and save it in the
XLStart folder as book.xlt.
 
M

moomoo

thank you.

But how do I do that? i mean what do you mean by creating
a template?
 
D

Dave Peterson

Start a new workbook.
Change the settings the way you want.

File|Save As
At the bottom of that dialog is a Save As Type: box.

Template (*.xlt) is not too far from the top.

But watch out, the folder changed when you weren't looking.

(Use Windows start button|Search (or Find) to find you XLStart folder.)
 

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

Top