Home |
Search |
Today's Posts |
#1
|
|||
|
|||
INITIAL FORMAT SETTINGS
how can i set the format settings for cell alignment so that its there when i
open a new book, rather than changing it each time? -- CHRISK |
#2
|
|||
|
|||
Chris,
Create a template file with the default formatting that you want,, named Book.xlt, and store it in your default start folder. Go to Tools / Options.... General Tab, and either use the folder in the "at startup, open all files in:" field, or enter a new folder path there. If that file already exists, you can open it and modify it. If the file doesn't exist, just start a new one and save it as a template file (xlt extension) to that folder. You can also create a template using a single sheet (named Sheet.xlt, and stored in the same folder) that will control how a single new sheet looks. I prefer to actually have both Sheet.xlt and Book.xlt be based on the same singe sheet file. When you add a new worksheet to an existing workbook, Excel will use Sheet.xlt. HTH, Bernie MS Excel MVP "CHRIS K" wrote in message ... how can i set the format settings for cell alignment so that its there when i open a new book, rather than changing it each time? -- CHRISK |
#3
|
|||
|
|||
just what I wanted
many thanks -- CHRISK "Bernie Deitrick" wrote: Chris, Create a template file with the default formatting that you want,, named Book.xlt, and store it in your default start folder. Go to Tools / Options.... General Tab, and either use the folder in the "at startup, open all files in:" field, or enter a new folder path there. If that file already exists, you can open it and modify it. If the file doesn't exist, just start a new one and save it as a template file (xlt extension) to that folder. You can also create a template using a single sheet (named Sheet.xlt, and stored in the same folder) that will control how a single new sheet looks. I prefer to actually have both Sheet.xlt and Book.xlt be based on the same singe sheet file. When you add a new worksheet to an existing workbook, Excel will use Sheet.xlt. HTH, Bernie MS Excel MVP "CHRIS K" wrote in message ... how can i set the format settings for cell alignment so that its there when i open a new book, rather than changing it each time? -- CHRISK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date format in excel not in line with control panel regional setti | Excel Discussion (Misc queries) | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
how to format numbers, digit grouping ,as per regional settings | Excel Discussion (Misc queries) | |||
Extracting Last Name and First Initial | New Users to Excel |