Basic Editing Techniques

When you work with Calc to create and edit your various spreadsheets, it is extremely important that you accurately enter your data, especially numerical values and formulas, otherwise there is no way the spreadsheet will provide you with an accurate portrayal of formula results. Spreadsheet software like Calc definitely subscribes to the adage “garbage in, garbage out.”

While we've already discussed basic data entry, let's look at some of the basic editing techniques and spreadsheet maintenance commands that will help when building simple and complex spreadsheets alike.

To Edit during Data Entry

While entering text or values in a cell, you do have the ability to edit your work if you make a mistake. As you are entering ...

Get StarOffice™ 5.2 Calc Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.