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 3.x Guide
Previous Page Home Next Page

Finding and replacing formulas or values

You can specify in the Find & Replace dialog either to find the parts of a formula or the results of a calculation.

  1. To open the Find & Replace dialog, use the keyboard shortcut Control+F or select Edit > Find & Replace.
  2. Click More Options to expand the dialog.
  3. Select Formulas or Values in the Search in drop-down list.
    • Formulas finds parts of the formulas.
    • Values finds the results of the calculations.
  4. Type the text you want to find in the Search for box.
  5. To replace the text with different text, type the new text in the Replace with box.
  6. When you have set up your search, click Find. To replace text, click Replace instead.

OpenOffice Calc 3.x Guide
Previous Page Home Next Page

  Published under the terms of the Creative Commons License Design by Interspire