View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben
 
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