Formatting sheets

J

jluckhoff

Hi,

Is there a way to cascade formatting in an xls?

I.e I have a xls with one sheet in it, for each new sheet added I woul
like it to have the formatting etc of the first sheet.

Is this possible?

Thanks,
 
G

Guest

Hi

You can set up a default for new sheets/workbooks but these are for all new
sheets/workbooks and not one default per workbook. Save a sheet with the
formatting you want (incl font, format, print layout, margins etc) and save
it as a template (xlt) called sheet.xlt in your XLStart folder. You can do
the same with a workbook and save that as a template called book.xlt in the
same folder.
 
J

jluckhoff

Thanks Andy,

Unfortunately I need to roll this out to a lot of users and I don
think I'd be very well liked if I were to permanently format all thei
exce sheets.

Would building a macro that can past the format from sheet to sheet b
a practical solution?

Then I can just add a button to the first sheet that says updat
format
 
D

Dave Peterson

Maybe you could just copy the original sheet and clear out the data from that
copy.

Rightclick on the worksheet tab to copy
select move or copy
(check that Copy box at the bottom of the next dialog!)
Tell it where to copy (before sheet ????).

Or you could just ctrl-click and drag it to where you want the copy.

(click and drag will move, ctrl-click and drag will copy.)
 
L

Lady Layla

???


:
:
: "Dave Peterson" wrote:
:
: > Maybe you could just copy the original sheet and clear out the data from
that
: > copy.
: >
: > Rightclick on the worksheet tab to copy
: > select move or copy
: > (check that Copy box at the bottom of the next dialog!)
: > Tell it where to copy (before sheet ????).
: >
: > Or you could just ctrl-click and drag it to where you want the copy.
: >
: > (click and drag will move, ctrl-click and drag will copy.)
: >
: > "jluckhoff <" wrote:
: > >
: > > Thanks Andy,
: > >
: > > Unfortunately I need to roll this out to a lot of users and I dont
: > > think I'd be very well liked if I were to permanently format all their
: > > exce sheets.
: > >
: > > Would building a macro that can past the format from sheet to sheet be
: > > a practical solution?
: > >
: > > Then I can just add a button to the first sheet that says update
: > > format.
: > >
: > > ---
: > >
: >
: > --
: >
: > Dave Peterson
: > [email protected]
: >
 
D

Dave Peterson

If all the sheets are laid out similarly,
just edit|move or copy sheets...
check that copy box
and copy to a new location.

then use that new copy as your starting point.
 
Top