ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Changing the Normal Style (https://www.excelbanter.com/excel-discussion-misc-queries/2550-changing-normal-style.html)

Randy Maheux

Changing the Normal Style
 
How can I chnage the Normal style in Excel 2000 so that new worksheets begin
with the cell formatting set to center vertically?

Dave Peterson

Styles are stored with each workbook.

So you could create a workbook that has the normal style you want. Then save
this workbook as a template for all new workbooks.

If that's what you want to do:
Start a new workbook.
Format|style|Modify
(and modify it to your heart's content)

Also, modify anything else you want as a standard--header/footers, page
orientation, number of worksheets in that workbook???

Now save it as a template in your XLStart folder as book.xlt

Then when you click on that New icon, the new workbook will inherit all those
settings.

===
You could create another template named sheet.xlt (stored in the same XLStart
folder) and any new worksheet you add to an existing workbook will inherit those
properties.


Randy Maheux wrote:

How can I chnage the Normal style in Excel 2000 so that new worksheets begin
with the cell formatting set to center vertically?


--

Dave Peterson


All times are GMT +1. The time now is 11:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com