O'Reilly logo

StarOffice™ 5.2 Calc Handbook by Joe Habraken

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using the Find and Replace Features

Since we have been looking at ways to enhance the look of your Calc spreadsheets, it makes sense to also take a look at some of the features that will assist you as you edit and fine-tune your spreadsheets. A very useful tool is the Find feature. It allows you to find a text or numeric string anywhere in your spreadsheet.

And if you wish to search for a particular item and then replace it, the Find feature has you covered. You can even search for items using a set of wildcard and placeholder characters that allows you to search for items by using a portion of a text or numerical string as the search string.

To start the Find feature, click the Find tool on the Main toolbar, or select Edit, then Find and Replace. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required