View Single Post
  #4   Report Post  
Old September 27th 09, 06:19 PM posted to microsoft.public.excel.setup
Gord Dibben Gord Dibben is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default Is there a settings startup file for Excel?

Unfortunately, there is no "beforesort" event so you cannot cancel the sort
if not all pertinent columns are selected.

I agree with Dave about creating a Table from your range as the easist
method to control the sort range.


On Sun, 27 Sep 2009 10:02:01 -0700, JimG

Thanks ... worked like a charm.
Any ideas about my other excel post this am? "Disable column only sorting
in Excel"


"Gord Dibben" wrote:

Open a new workbook. Customize as you the sheets before
setup so's all sheets get same settings.

FileSave As Type: scroll down to Excel Template(*.XLT) and select. Name
your workbook "BOOK"(no quotes). Excel will add the .XLT to save as

Store this workbook in the XLSTART folder usually located at........

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

This will be the default workbook for FileNew or the Toolbar button
FileNew or CTRL + n

WARNING................Do not use FileNew...Blank Workbook or you will get
the Excel default workbook.

NOTE: Existing workbooks are not affected by these settings.

You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes
the default InsertSheet.

More can be found on this in Help under "templates"(no quotes).

Instructions are for Excel 2003 and earlier.

2007 is similar except you would save as BOOK.xltx

Gord Dibben MS Excel MVP

On Sun, 27 Sep 2009 07:50:02 -0700, JimG

I create hundreds of excel spreadsheets and would like excel to startup with
the following settings:
1. Alignment - Vertical set to "Top"
2. Default number field set to number with 2 decemal places and a comma.
3 Text Control - Wrap = Off

The current default vertical allignment set to Bottom and wrap on causes
information display problems. To a novice user a cell can appear to be

Is there a startup settings file that can be changed for Excel or some
secret setting within Excel to do the above? If so, how?