Can I change Excel default settings (two issues)

[_Alan_]

Issue #1: (Row height) I always want my row height to be 20.0, but Excel
97 at work is set by default to 12.75, and the Excel 2003 at home is at
13.5. Am I stuck with that? Do I *always* have to manually change to 20,
or is there some way I can change the default height to 20?

Issue #2: (Text Import Wizard) Step 3 of the Text Import Wizard defaults
to "General" in regard to the "Column Data Format". I *always* want to use
"Text". Must I always select the columns and switch to text, or is there
some way I can instruct Excel to default to the "Text" setting in the Text
Import Wizard?

I know we're talking eliminating a few mouse-clicks and a few keystrokes,
and it doesn't seem like much, but I have to prepare at least 10
spreadsheets a day, and it's getting to be a little irritating. I bet
there's a way I can make Excel get used to doing what I want it to do, but I
just haven't been savvy enough to figure it out.

Help will be greatly appreciated. Thank you.

 

[JE McGimpsey]

#1) See XL Help "Create a template for workbooks or worksheets", and
follow the directions for creating a default template. Before saving,
set your row height to 20.0.

#2) I don't know of a way of changing the defaults, but if your text
files are always formatted the same way, you may be able to record a
macro so that it's done automatically.

 

[_Alan_]

#1) See XL Help "Create a template for workbooks or worksheets", and
follow the directions for creating a default template. Before saving,
set your row height to 20.0.

Thanks --- I tried to go the template route once, but found the Help
instructions singularly unehlpful. Perhaps I'll give it another go. Too bad
something that simple for an Excel spreadsheet couldn't be handled as easily
as it is for a Word document . . .

#2) I don't know of a way of changing the defaults, but if your text
files are always formatted the same way, you may be able to record a
macro so that it's done automatically.

Unfortunately, the text files that I import have different numbers of
columns and other
different things have to be done (some have columns that need to be skipped,
etc, etc), so it'd probably be much more trouble to create separate macros.
(sigh)

Thanks very much for your suggestions.

 

[JE McGimpsey]

Too bad something that simple for an Excel spreadsheet couldn't be
handled as easily as it is for a Word document . . .

Seems exactly as easy to me, though I won't vouch for the Help
instructions...

Save a template in the Startup folder named "Book.xlt", formatted
exactly the way you want it.