A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Default Row Height in Excel 2003



 
 
Thread Tools Display Modes
  #1  
Old November 30th, 2005, 01:11 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default Default Row Height in Excel 2003

This may have been covered before - and apologies if so - but I can't change
the default row height from 12.75 to 15.00 each time I open excel 2003. I
have tried saving as book1.xlt , book.xlt and even renaming the original
book1.xlt to bookold.xlt but still when I open up excel the default row
height remains 12.75
Would really appreciate if someone could either let me know how to do this
or if version 2003 won't let you! I know I did it in version 97
  #2  
Old November 30th, 2005, 06:48 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default Default Row Height in Excel 2003

derek

Where are you saving BOOK.XLT?

It must be saved into your XLSTART folder, usually at

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

When you go to FileNew the workbook opened will be based upon that template.

You can also make a SHEET.XLT and store it same folder.

That will be the Template for any InsertWorksheet.


Gord Dibben Excel MVP



On Wed, 30 Nov 2005 06:11:27 -0600, "derek
wrote:

This may have been covered before - and apologies if so - but I can't change
the default row height from 12.75 to 15.00 each time I open excel 2003. I
have tried saving as book1.xlt , book.xlt and even renaming the original
book1.xlt to bookold.xlt but still when I open up excel the default row
height remains 12.75
Would really appreciate if someone could either let me know how to do this
or if version 2003 won't let you! I know I did it in version 97


  #3  
Old December 1st, 2005, 06:07 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default Default Row Height in Excel 2003

Thanks for taking the time to reply, but it don't work for me!! I did
locate the .xlt file and did a "save as" thus overwriting, but when I closed
excel and re-opened there was the blessed 12.75 row hight still small as
life!! As I say, perhaps it can't be changed in 2003 as in 97.
Cheers
Derek
  #4  
Old December 1st, 2005, 08:34 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default Default Row Height in Excel 2003

Derek

Open a new blank workbook from FileNew...Blank workbook

Select all sheets by right-click on a sheet tab and "select all sheets".

CTRL + a(twice) to select all cells.

FormatRowHeight. Set to 15

Right-click on a shee tab and "ungroup sheets".

FileSave AsFile TypeTemplate(*.xlt)

Browse to the correct XLSTART folder(there can be several on your computer)

The correct XLSTART folder will be at

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

username will be your name in the path.

Type in BOOK. Excel will add the .XLT

Close Excel then re-open and check the row heights.

NOTE: FileNew...Blank Workbook will not be based upon the BOOK.XLT template.

FileNew(no ellipsis) will be based on BOOK.XLT

New File Icon will be based upon BOOK.XLT


Gord

On Thu, 1 Dec 2005 11:07:24 -0600, "derek
wrote:

Thanks for taking the time to reply, but it don't work for me!! I did
locate the .xlt file and did a "save as" thus overwriting, but when I closed
excel and re-opened there was the blessed 12.75 row hight still small as
life!! As I say, perhaps it can't be changed in 2003 as in 97.
Cheers
Derek


  #5  
Old December 3rd, 2005, 06:15 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default Default Row Height in Excel 2003

Yippee Yippee Yippee - this worked!!

Many, many thanks for your time and trouble in answering my problem

Derek
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excell VS Office Cathyandrea General Discussion 1 September 19th, 2005 07:02 AM
Word 2002 and Word 2003 trading default file association Enochscion General Discussion 2 May 27th, 2005 10:19 PM
how can i change the default settings in excel 2003? bif General Discussion 0 May 25th, 2005 02:24 PM
Modifying Default Colors in Excel 2003 Reader Setting up and Configuration 1 May 20th, 2005 03:47 PM
After installing Windows XP SP2 , how do I open old Excel 2003 fil Mike D General Discussion 2 September 2nd, 2004 10:21 PM


All times are GMT +1. The time now is 03:26 PM.


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