 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2008How to set default cell formattiing to vertical alignment = top ??
How to set 'Alignment', 'Vertical:' cell formatting to be 'Top' as default format for all new worksheets ?  Signatureakm Thanks again for your help. ---- Ah, the miracle of computers!... someone also said "To error is human, but to really screw up it takes a computer!" Take a look at "default workbook" in XL Help. > How to set 'Alignment', 'Vertical:' cell formatting to be 'Top' as default > format for all new worksheets ? JE Thanks for the reply, but dont find anything for a 'vertical alignment' default setting. Most 'help' sections refer to 'options', but cant find any such setting in 'options'. What am I missing ? Signatureakm Thanks again for your help. > Take a look at "default workbook" in XL Help. > > How to set 'Alignment', 'Vertical:' cell formatting to be 'Top' as default > > format for all new worksheets ? Basically, you create a template and save it as Book.xlt in your XLSTART folder. You can also save a single sheet as SHEET.xlt. In these templates you set things up exactly as you want them to appear in a blank workbook or for a newly-inserted worksheet, including things like headers and footers, formatting of cells, font size and type etc. Hope this helps. Pete > JE > Thanks for the reply, but dont find anything for a 'vertical alignment' [quoted text clipped - 14 lines] > > - Show quoted text - Pete Thanks very much for the info. I put a file (eg with special column widths) called Book.xlt in the XLstart folder at C:\Program Files\Microsoft Office\Office\XLStart. Doesnt appear that Excel opens that workbook (as a default) each time a new workbook is started ? That would seem like a good way to work around the fact that Excel doesnt offer the setting in 'options' etc, but how do I get that to happen (ie create a template that will be that default workbook used by Excel when starting/opening a new workbook (Book.xls) file ? Is there a way to do that ? Thanks again for your help. akm > Basically, you create a template and save it as Book.xlt in your > XLSTART folder. You can also save a single sheet as SHEET.xlt. [quoted text clipped - 26 lines] > > > > - Show quoted text - Did you save the workbook as a Template(*.xlt) or just name it Book.xlt? If properly done........................ If you clicked on File>New...Blank workbook, you will get the Excel default workbook. File>New or click on New File Icon to get your revised workbook. For location of XLSTART folder.................... C:\Documents and Settings\Gord\Application Data\Microsoft\Excel\XLSTART Gord would be your username. Gord Dibben MS Excel MVP >Pete >Thanks very much for the info. [quoted text clipped - 45 lines] >> > >> > - Show quoted text - Gord Thanks for the reply. Appears Ive done what you describe... 1. Saved a new workbook (with special column widths as a test case) as a Template(*.xlt), named it Book1.xlt, in C:\Documents and Settings\akm\Application Data\Microsoft\Excel\XLSTART 2. Closed Excel 3. Opened Excel and clicked on new workbook icon 4. New workbook did not open as test case template file What am I missing ? Signatureakm Thanks again for your help. > Did you save the workbook as a Template(*.xlt) or just name it Book.xlt? > [quoted text clipped - 62 lines] > >> > > >> > - Show quoted text - You must name it "Book"(no quotes) and let Excel add the .xlt part Do not name it Book1 See from Pete's original post...... > >> Basically, you create a template and save it as Book.xlt in your > >> XLSTART folder. You can also save a single sheet as SHEET.xlt. Gord >Gord >Thanks for the reply. [quoted text clipped - 8 lines] > >What am I missing ? Gord That seems to have done it, thanks for sticking with me on this one ! Not much of a geek, so dont know how to return the favor, but if there was a way Id try. Signatureakm Thanks again for your help ! > You must name it "Book"(no quotes) and let Excel add the .xlt part > [quoted text clipped - 18 lines] > > > >What am I missing ? Around here we return favors by one day helping someone else, which I'm sure you will have opportunity to do. As we used to say up North...........Don't pay me. Just don't pass by the next car you see in the ditch. Gord >Gord >That seems to have done it, thanks for sticking with me on this one ! >Not much of a geek, so dont know how to return the favor, but if there was a >way Id try. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.