Results 1 to 4 of 4

Default row height in excel

This is a discussion on Default row height in excel within the Excel Questions forums, part of the Question Forums category; Hi, Is there anyway of changing the default row height from 12.75 to say 15 in Excel. I want this ...

  1. #1
    Board Regular
    Join Date
    May 2003
    Posts
    260

    Default Default row height in excel

    Hi,

    Is there anyway of changing the default row height from 12.75 to say 15 in Excel. I want this as a permanent change rather than doing this everytime I create a new workbook. I know by changing the default font size to Arial 12 does change the row height but I want my font size to remain at 10.

    I'm using Excel 97 if anyone can help please let me know.

    Thanks
    Jon

  2. #2
    Board Regular Diablo II's Avatar
    Join Date
    Sep 2008
    Location
    Tampa Fl
    Posts
    538

    Default Re: Default row height in excel

    one way is to make a new workbook set the cell the way you wont them, then save as templete, then you just open the templete when you need a new workbook.

  3. #3
    MrExcel MVP
    Moderator
    Rediscovering the love
    Richard Schollar's Avatar
    Join Date
    Apr 2005
    Location
    UK
    Posts
    23,666

    Default Re: Default row height in excel

    Hi Jon

    I don't have xl97 here at work, but the way to do it in 2000 or later would be to save down a workbook template with your required default settings in your XLSTART folder with the name "Book.xlt". Also save down a single worksheet with your default settings into XLSTART and call it "Sheet.xlt".

    This way, whenever you add a new workbook or add a new sheet to an existing workbook, the default settings in the two files above will be used.

    It *probably* works in 97 too.
    Richard Schollar

    Using xl2013

  4. #4
    Board Regular
    Join Date
    May 2003
    Posts
    260

    Default Re: Default row height in excel

    Thanks for tip guys.

    Jon

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com