After creating the default text do the following:

Click FILE in the menu and select SAVE AS

In the dialog box change the SAVE AS TYPE to Template.

Excel will add the xlt extension to the filename and change the save
directory to the local TEMPLATES folder.

You will have to distribute this to your user group or copy it to network
drive that everyone has access to.

To use the template click FILE in the menu and select NEW. If you're using
Excel 2000 the templates dialog box will display, if you're using 2003 the
taskpane on the right of the screen asks you to select where the template is
located. Select ON MY COMPUTER and then select the template from the list
(if it's local) or browse and locate the file from the public directory on
the network.


--
Kevin Backmann


"Cindy" wrote:

what if is a template and they want to put info in but not want to have the
hassle of doing this


"Kevin B" wrote:

Click the tab of sheet 1 and then while holding down a shift key, click on
sheet 3.

Your text, formatting and formulas will now populate across all 3 worksheets.

Right click on a selected worksheet tab and select UNGROUP when done, or
just click on any unselected workhsheet tab to remove grouping.
--
Kevin Backmann


"Cindy" wrote:

I need the info from page one of the workbook to automatically go to pages 2
& 3 how would i do this