Worksheet Templates

Topic

New Reply

Does anyone know how I can use a worksheet template internally in a workbook to use the same formatting on a number of worksheet. If I just copy I loose row and column widths. Anyone have any other suggestion on how to make all worksheets appear with the same format? I have a user who is wanting to keep all his budgets in one workbook, but also needs to keep the same format. All your ideas are welcome and thanks in advance. Judy

Reply | Quote

Replies

If you copy an entire row or column or the whole sheet and paste it, the column widths and/or row widths would go with it. You can also copy an entire sheet, and then do a Paste Special Formats to duplicate the formatting without changing the cell contents. You could also put code in the Workbook Newsheet event routine to copy the formatting from an existing sheet and paste it into the new sheet. Does any of that help?

Reply | Quote

Thanks so much I tried your suggestions and they work well. Also tried Andrew’s, and it is a great suggestion, too. So glad for this group and can’t even reach you to let you know. Judy

Reply | Quote

Probably the simplest thing for your user to do would be to set up a blank worksheet with the formatting he wants. If Column or Row headings are the same for each sheet, they could be set up as well. Then any time a new sheet is needed, instead of inserting a worksheet, go to Edit, Move or Copy Sheet, and then make sure that Create a copy is ticked and select Move to end. Then name the new sheet as required.

Andrew C

Reply | Quote

Thanks so much Andrew, why didn’t I think of this. I appreciate your help so much. I’m indebted and can’t even send cookies through cyberspace! Judy

Reply | Quote