How do I set up worksheets to match?

D

DrNick48

When I select the INSERT WORK SHEET function in a workbook, the 2nd and
subsequent worksheets don't match the first one. I've searched for WORKSHEET
TEMPLATE directions to no avail. of course, it IS a Monday... LOL

What am I missing?

TN X!!!

(e-mail address removed)
 
J

jaf

Hi,
When you insert a worksheet you get a new blank worksheet.

If you have a preformatted sheet, right click the sheet tab, select move or copy sheet.
Check the "copy" box and you will get a duplicate sheet.

John
 
G

Gord Dibben

Do you want to have a particular formatted and designed worksheet to be
inserted?

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

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 SHEET.xltx


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match and Vlookup issue 2
How do I enter data simultaneously on mulitiple worksheets? 2
match data by day 1
How do I view multiple worksheets on different monitors? 1
How do I apply print settings to all worksheets 1
Combining Multilple Worksheets Into One 6
Search and Link across worksheets 2
How to do an IF statement that copy data based on a partial match 0

Top