98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel course in london - Tracking changes
excel course in london - Tracking changes
Resolved · 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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Auto-insert the current timeIn Microsoft Excel, to enter the current time into a cell, hold CTRL+SHIFT and press SEMICOLON. |