Default row height in excel

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Default row height in excel

  1. #1
    Board Regular
    Join Date
    May 2003
    Posts
    349
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Inactive
    Richard Schollar's Avatar
    Join Date
    Apr 2005
    Location
    UK
    Posts
    23,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    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
    349
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Default row height in excel

      
    Thanks for tip guys.

    Jon

User Tag List

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