Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




OpenOffice Calc User Guide
Previous Page Home Next Page

Recording changes

For this chapter we will work with a budget proposal for a baseball team.


Figure 112 shows the budget spreadsheet your coach submitted.


Looking over the figures, you see a few places where money could be saved:

  • Post-game snacks can be bought by parents.

  • New uniforms can wait, only buy 10 to replace broken ones.

  • Buy cheaper baseballs.

  • Only buy 2 spare gloves.

To make these changes, use the record changes feature in Calc. To start Calc recording changes:

  1. Open the Budget Spreadsheet.

  2. Select Edit > Changes > Record (Figure 113) from the menu bar.


  1. Begin editing the document.

Red borders appear around the cells where changes were made (Figure 114). Other reviewers then quickly know which cells were edited.


To change the color that indicates changes, select Tools > Options > Calc > Changes.


Once you finish editing the document, you can send it to your coach. However, you may want to explain your rationale for the changes. You can add comments or notes to accomplish this.

OpenOffice Calc User Guide
Previous Page Home Next Page

  Published under the terms of the Open Publication License Design by Interspire