| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I set up worksheets to match?
|
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
How do I set up worksheets to match?
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 "DrNick48" wrote in message ... 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!!! |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
How do I set up worksheets to match?
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 InsertSheet. 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 On Mon, 22 Jun 2009 11:30:01 -0700, DrNick48 wrote: 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!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| trying to match text in 2 worksheets | Excel Worksheet Functions | |||
| How to match to Worksheets | Excel Worksheet Functions | |||
| MATCH function through multiple worksheets | Excel Worksheet Functions | |||
| Look for match on two worksheets | Excel Worksheet Functions | |||
| Can you match records from two different worksheets | Excel Worksheet Functions | |||
Linear Mode
