excel course in london - tracking changes

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel course in london - Tracking changes

excel course in london - Tracking changes

resolvedResolved · Low Priority · Version Standard

Vintha has attended:
Excel Intermediate course
Excel Advanced course

Tracking changes

how do i track changes on a spreadsheet?
Can i record each change accordingly for future use by others?

RE: tracking changes

To track changes you need to first share the workbook, and then enable tracking.

On the Tools menu, click Share Workbook, and then click the Editing tab.
Select the Allow changes by more than one user at the same time check box.
Click the Advanced tab.
Under Track changes, click Keep change history for, and in the Days box, type the number of days of change history that you want to keep.

(change history: In a shared workbook, information that is maintained about changes made in past editing sessions. The information includes the name of the person who made each change, when the change was made, and what data was changed.)

Click OK, and if prompted to save the file, click OK.

I recommend reading through the Excel help file to familiarise yourself with how it works. Simply type "track changes" into the help search area of excel.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 


Server loaded in 0.73 secs.