Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Randy Maheux
 
Posts: n/a
Default 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?
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing font size in a list box [email protected] Excel Discussion (Misc queries) 1 December 21st 04 04:07 PM
How to format a number in Indian style in Excel? Victor_alb Excel Discussion (Misc queries) 2 December 21st 04 04:21 AM
Excel should not be an MDI style application. Robert Brown Excel Discussion (Misc queries) 4 December 14th 04 12:18 AM
bell-shape normal distribution curve SM Charts and Charting in Excel 6 December 11th 04 08:29 PM
How can I change size of the picture without changing chartobject? Marie J-son Charts and Charting in Excel 6 December 7th 04 12:34 PM


All times are GMT +1. The time now is 09:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"