Excel 2007 - Changing Defaults (Row Height)

[ladyck3]

Hi,

I've been able to customize Excel 2007 pretty much to all of my old settings. But the one thing that I'm unable to 'fix' is the default row height. In previous versions the default was 12.75. In 2007 the default is set to 15.. is there any way to change the default spreadsheet to 12.75 so subsequent worksheet/books will default to that setting rather than having to manually adjust for EVERYTHING??

Thanks in advance....

(there has got to be a way to configure the default spreadsheet like the normal.dot (dotx) for Word.

HELP!!



LadyCK3
aka: Laurie

 

[AnotherHiggins]

-> there has got to be a way to configure the default spreadsheet like the normal.dot

I don't have 2007 yet (whew!), but I if it has normal.dot then I assume this is also the same....

Excel's version of that is BOOK.XLT and SHEET.XLT.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[ladyck3]

Well, actually you "can" come over to the dark side, 2007 really isn't bad at all now that I'm used to it... it became a company standard a couple of months ago. I'm having a few issues with access (learning curve) but Excel is coming along nicely.

I just have this ONE customization I cannot locate and I'm unable to locate the 'template' for a standard worksheet.
Note: File extensions now have an x at the end. XLTX or XLSX, or DOTX or DOCX, you get the picture.




LadyCK3
aka: Laurie

 

[ladyck3]

THANK ME! I figured it out!!!
I had the default font set to Calibri (I love this even more than Arial.... its awesome, thanks 2007) but it was set to 11, I changed it to 10 and it changed the row height when I restarted Excel.

WOO HOO.... I was still poking around and decided to give THAT a try and it worked! GOLD STARS FOR ME heheheh Just Kidding



LadyCK3
aka: Laurie

 

[AnotherHiggins]

Thanks, that's good to know. But seeing as we still have a few users on Office 2000, I doubt we'll be switching company-wide to 2007 any time soon. In my company's defense, the folks on 2000 are in a call center and don't use office as part of their regular job duties.

On with the fun:
The file doesn't exist until you create it.

Set up a sheet the way you want, then save it as sheet.xltx. Unless they've changed it, the path where you save it is:

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


[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[SkipVought]

I usually choose a fixed pitch font in Excel, like Courier, because columnar data looks better and seems easier to read, when the characters within the columns align as well.

IMHO (well, maybe somwhat lacking in H), variable pitch fonts are better for word processing while fixed pitch fonts are better for tables.

Just my 2[¢]

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[ladyck3]

Hey Skip...

If I "HAVE" to pick a fixed font I choose either Courier New or Lucida Console.... I prefer "san serif" type fonts.

It dives me nutz that my hubby uses Times New Roman on everything BY CHOICE... <shiver> Can't stand it

Thanks for the 2¢..



LadyCK3
aka: Laurie

 

[SkipVought]

I wish they made more fixed pitch fonts. There are so few. *sigh*

I font to haf my vay! ;-)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}