#1   Report Post  
Old September 16th 05, 05:40 PM
Steve
 
Posts: n/a
Default Formatting

Is it possible to set up Excel so each time any new file is open the footer
information can be the same for each new spreadsheet? I would like to see
the same footer in each new file without having to manually insert the
footers Also, if I want the default column width to be different than it is
for each new file, can I do that?

Thanks,

  #2   Report Post  
Old September 16th 05, 07:15 PM
Dave Peterson
 
Posts: n/a
Default

If you start a new workbook and change the page layout (for all the sheets), you
can save it into your XLStart folder as Book.xlt (as a template file).

Excel will use that as the basis for new workbooks when you click on the New
icon on the standard toolbar.

You can change a lot of settings that way--including orientation,
headers/footers, columnwidth...

===
And you can make a separate template workbook and name it sheet.xlt.

Then any sheet you add to existing workbooks will inherit these settings. Save
it as a template in the same XLStart folder.



Steve wrote:

Is it possible to set up Excel so each time any new file is open the footer
information can be the same for each new spreadsheet? I would like to see
the same footer in each new file without having to manually insert the
footers Also, if I want the default column width to be different than it is
for each new file, can I do that?

Thanks,


--

Dave Peterson
  #3   Report Post  
Old September 16th 05, 07:42 PM
Steve
 
Posts: n/a
Default

Cool, let me try that. Thanks,


"Dave Peterson" wrote:

If you start a new workbook and change the page layout (for all the sheets), you
can save it into your XLStart folder as Book.xlt (as a template file).

Excel will use that as the basis for new workbooks when you click on the New
icon on the standard toolbar.

You can change a lot of settings that way--including orientation,
headers/footers, columnwidth...

===
And you can make a separate template workbook and name it sheet.xlt.

Then any sheet you add to existing workbooks will inherit these settings. Save
it as a template in the same XLStart folder.



Steve wrote:

Is it possible to set up Excel so each time any new file is open the footer
information can be the same for each new spreadsheet? I would like to see
the same footer in each new file without having to manually insert the
footers Also, if I want the default column width to be different than it is
for each new file, can I do that?

Thanks,


--

Dave Peterson

  #4   Report Post  
Old November 26th 05, 10:31 PM posted to microsoft.public.excel.setup
Karlv
 
Posts: n/a
Default Formatting

I would like to change the DEFAULT template so that when XL opens, I get "my"
customised version

"Steve" wrote:

Cool, let me try that. Thanks,


"Dave Peterson" wrote:

If you start a new workbook and change the page layout (for all the sheets), you
can save it into your XLStart folder as Book.xlt (as a template file).

Excel will use that as the basis for new workbooks when you click on the New
icon on the standard toolbar.

You can change a lot of settings that way--including orientation,
headers/footers, columnwidth...

===
And you can make a separate template workbook and name it sheet.xlt.

Then any sheet you add to existing workbooks will inherit these settings. Save
it as a template in the same XLStart folder.



Steve wrote:

Is it possible to set up Excel so each time any new file is open the footer
information can be the same for each new spreadsheet? I would like to see
the same footer in each new file without having to manually insert the
footers Also, if I want the default column width to be different than it is
for each new file, can I do that?

Thanks,


--

Dave Peterson

  #5   Report Post  
Old November 27th 05, 03:42 AM posted to microsoft.public.excel.setup
Dave Peterson
 
Posts: n/a
Default Formatting

I have book.xlt in my XLStart folder. When I start excel, I get an empty
workbook based on that template.

Doesn't this happen when you create your book.xlt template in your XLStart
folder?

Karlv wrote:

I would like to change the DEFAULT template so that when XL opens, I get "my"
customised version

"Steve" wrote:

Cool, let me try that. Thanks,


"Dave Peterson" wrote:

If you start a new workbook and change the page layout (for all the sheets), you
can save it into your XLStart folder as Book.xlt (as a template file).

Excel will use that as the basis for new workbooks when you click on the New
icon on the standard toolbar.

You can change a lot of settings that way--including orientation,
headers/footers, columnwidth...

===
And you can make a separate template workbook and name it sheet.xlt.

Then any sheet you add to existing workbooks will inherit these settings. Save
it as a template in the same XLStart folder.



Steve wrote:

Is it possible to set up Excel so each time any new file is open the footer
information can be the same for each new spreadsheet? I would like to see
the same footer in each new file without having to manually insert the
footers Also, if I want the default column width to be different than it is
for each new file, can I do that?

Thanks,

--

Dave Peterson


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
difficulty with conditional formatting Deb Excel Discussion (Misc queries) 0 March 23rd 05 07:13 PM
conditional formatting question Deb Excel Discussion (Misc queries) 0 March 23rd 05 03:07 AM
Formatting dates in the future Compass Rose Excel Worksheet Functions 3 January 17th 05 11:39 PM
Copy conditional formatting across multiple rows? Gil Excel Discussion (Misc queries) 1 January 11th 05 12:27 PM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 04:33 PM


All times are GMT +1. The time now is 07:38 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017