Creating a custom cell style MDW 25.11.2005 13:40:02 When I go into Excel 2003 help, under "Formatting Cells", it gives the following instructions: 1. On the Sheet tab, in the Quick Formatting group, click Cell Styles. 2. Click New Cell Style. .... Now, I've been using Excel for years, but try as I might, I can't for the life of me figure out where the "Quick Formatting group" is, or what "Sheet tab" to look for. Can anyone help me with a translation? -- Hmm...they have the Internet on COMPUTERS now!

Re: Creating a custom cell style Gord Dibben <gorddibbATshawDOTca> 25.11.2005 17:46:45 Don't know where you found that "help" under Help, but......... To change Styles go to Format>Style and add or modify Styles as you wish. Gord Dibben Excel MVP On Fri, 25 Nov 2005 05:40:02 -0800, MDW <MDW[ at ]discussions.microsoft.com> wrote: [Quoted Text] >When I go into Excel 2003 help, under "Formatting Cells", it gives the >following instructions: > >1. On the Sheet tab, in the Quick Formatting group, click Cell Styles. >2. Click New Cell Style. >... > >Now, I've been using Excel for years, but try as I might, I can't for the >life of me figure out where the "Quick Formatting group" is, or what "Sheet >tab" to look for. > >Can anyone help me with a translation?

Re: Creating a custom cell style MDW 25.11.2005 17:56:03 Now, see, I tried that, but two weird things happened.. 1) The "Add" button for styles was grayed out. 2) I modified the comma style (since I don't use it) to be what I wanted (in this case, a date style)...but after I closed Excel and went back in, the old styles had reverted back to the way they were. ??? -- Hmm...they have the Internet on COMPUTERS now! "Gord Dibben" wrote: [Quoted Text] > Don't know where you found that "help" under Help, but......... > > To change Styles go to Format>Style and add or modify Styles as you wish. > > > Gord Dibben Excel MVP > > On Fri, 25 Nov 2005 05:40:02 -0800, MDW <MDW[ at ]discussions.microsoft.com> wrote: > > >When I go into Excel 2003 help, under "Formatting Cells", it gives the > >following instructions: > > > >1. On the Sheet tab, in the Quick Formatting group, click Cell Styles. > >2. Click New Cell Style. > >... > > > >Now, I've been using Excel for years, but try as I might, I can't for the > >life of me figure out where the "Quick Formatting group" is, or what "Sheet > >tab" to look for. > > > >Can anyone help me with a translation? > >

Re: Creating a custom cell style Gord Dibben <gorddibbATshawDOTca> 25.11.2005 18:37:01 The "Add" button will be grayed out until you type a new name into the dialog box. Try this.........in the dialog box select any style. That style name will be highlighted in black in the box. Just type a new name in there. Make any changes you need and OK. Save the workbook. Custom Styles are saved with the workbook and are not Global. When you want to use that style select the cell(s) and Format>Style. Select your newname style and OK. Gord On Fri, 25 Nov 2005 09:56:03 -0800, MDW <MDW[ at ]discussions.microsoft.com> wrote: [Quoted Text] >Now, see, I tried that, but two weird things happened.. > >1) The "Add" button for styles was grayed out. >2) I modified the comma style (since I don't use it) to be what I wanted (in >this case, a date style)...but after I closed Excel and went back in, the old >styles had reverted back to the way they were. > >???

Re: Creating a custom cell style Gord Dibben <gorddibbATshawDOTca> 25.11.2005 18:51:44 Open a new workbook. Customize as you wish. File>Save As Type: scroll down to Excel Template(*.XLT) and select. Name your workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT. Store this workbook in the XLSTART folder usually located at........ C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART This will be the default workbook for File>New Existing workbooks are not affected by these settings. You can also open a new workbook and delete all but one sheet. Customize as you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes the default Insert>Sheet. More can be found on this in Help under "templates"(no quotes). More things to know about Custom Styles................ Open the workbook with the custom style. Open another previously saved workbook and Format>Style. Type in the same name as the one in first workbook then "merge". You will be asked if you want to merge styles with same name. Click yes and newname style from first book will now be a style in second book. Save second book. Gord On Fri, 25 Nov 2005 10:37:01 -0800, Gord Dibben <gorddibbATshawDOTca> wrote: [Quoted Text] >The "Add" button will be grayed out until you type a new name into the dialog >box. > >Try this.........in the dialog box select any style. That style name will be >highlighted in black in the box. > >Just type a new name in there. Make any changes you need and OK. > >Save the workbook. Custom Styles are saved with the workbook and are not >Global. > >When you want to use that style select the cell(s) and Format>Style. > >Select your newname style and OK. > > >Gord > >On Fri, 25 Nov 2005 09:56:03 -0800, MDW <MDW[ at ]discussions.microsoft.com> wrote: > >>Now, see, I tried that, but two weird things happened.. >> >>1) The "Add" button for styles was grayed out. >>2) I modified the comma style (since I don't use it) to be what I wanted (in >>this case, a date style)...but after I closed Excel and went back in, the old >>styles had reverted back to the way they were. >> >>???