ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Worksheet-template (HELP!) (https://www.excelbanter.com/excel-programming/354363-worksheet-template-help.html)

at_a_loss

Worksheet-template (HELP!)
 
Can someone tell me in lamen's terms how to create a worksheet and them be
able to make it a template or a form so that I can highlight everything and
only delete the data just entered instead of the whole sheet? PLEASE HELP!

Chris Marlow

Worksheet-template (HELP!)
 
Hi,

A 'template' can mean many things - an XLT file is an Excel file that is in
many ways like an ordinary excel file - however when users double click in
Explorer they open a new instance of the file - rather than the original. The
can also be added to the template directories and appear under the 'New from
template' area of task pane.

However a template could also mean just making a copy of the original for
each editor. Depends how you want to play it.

In either case if you want to track changes you can select 'Tools', 'Track
Changes', 'Highlight Changes' - then distribute your workbook/template. When
the workbook is finished with you can use 'Tools', 'Track Changes' and
'Accept or Reject Changes ...' which allows you to find out & undo what was
changed.

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"at_a_loss" wrote:

Can someone tell me in lamen's terms how to create a worksheet and them be
able to make it a template or a form so that I can highlight everything and
only delete the data just entered instead of the whole sheet? PLEASE HELP!



All times are GMT +1. The time now is 11:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com