Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I repeat the copying of a worksheet?
The work book I am creating has 100's of worksheets with the same format, but
different info. The inputing of data, as well as the linking is not an issue. I want to repeat the copy function of a worksheet w/o having to right click and do it manually everytime, but "F4" does not seem to help. I'm confused, what keyboard function can do what I want to do? |
#2
|
|||
|
|||
If you just want to copy the sheet with its formatting but no data.....
Open a New Workbook, delete all but one sheet. Format as you wish. FileSave AsFile TypeExcel Template(*.xlt) Name it SHEET and store it in your XLSTART folder. It will become the InsertWorksheet default sheet. SHIFT + F11 will insert a new sheet. Gord Dibben Excel MVP On Mon, 23 May 2005 10:36:03 -0700, "mgarbanz" wrote: The work book I am creating has 100's of worksheets with the same format, but different info. The inputing of data, as well as the linking is not an issue. I want to repeat the copy function of a worksheet w/o having to right click and do it manually everytime, but "F4" does not seem to help. I'm confused, what keyboard function can do what I want to do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Copying Worksheet | Excel Worksheet Functions | |||
Copying Numerical Totals of separate worksheets to a single Summary Worksheet | Excel Discussion (Misc queries) | |||
Copying Totals of separate worksheets to a single Summary Worksheet | Excel Discussion (Misc queries) | |||
copying formulas from worksheet to worksheet | Excel Discussion (Misc queries) | |||
hyperlinks and copying a worksheet | Excel Worksheet Functions |