- Editing Data
- Overwriting and Deleting Data
- Undoing and Redoing Changes
- Inserting Cells
- Deleting Cells
- Inserting and Deleting Rows
- Inserting and Deleting Columns
- Cutting, Copying, and Pasting Data
- Flipping Rows and Columns
- Moving Data
- Finding Data
- Replacing Data
- Adding and Viewing Cell Comments
- Editing and Deleting Cell Comments
- Inserting Symbols
- Tracking Changes
- Accepting or Rejecting Tracked Changes
- Checking Spelling
This chapter is from the book
This chapter is from the book
This chapter is from the book
Tracking Changes
Suppose you’re working on a team project, and each member has access to the same workbook. To keep track of who makes what changes to the workbook, you can use Excel’s Track Changes feature; that way, each person’s edits appear in a different color. An edit can be changing the current information or adding completely new information to the workbook. (The only time the colors won’t be different is when two people use the same computer or user information–such as login or password.)
)
)
Open the Tools menu, choose Track Changes, and select Highlight Changes to open the Highlight Changes dialog box.
Click the Track Changes While Editing. This Also Shares Your Workbook checkbox to select it.
The Highlight Which Changes options become available; click OK to accept the default change options.
)
Excel notifies you that the workbook will be saved; click OK. The workbook is now shared, with Track Changes enabled.
Type a change in a cell and press Enter. The upper-left corner of the cell now contains a Track Changes marker, and a colored border.
Move the mouse pointer over the revised cell. A ScreenTip appears, showing the change that was made, who made the change,
and when.
)