Close Help Center ONLYOFFICE Documents for iOS Spreadsheet Editor Document Editor complete documentation User guides ONLYOFFICE Workspace ONLYOFFICE Groups ONLYOFFICE Docs Mail Server Talk Module ONLYOFFICE Groups Documents Module People Module Commmunity Module CRM Module Projects Module Mail Module Calendar Module ONLYOFFICE Docs Document Editor Spreadsheet Editor Presenetation editor ONLYOFFICE Mobile Apps ONLYOFFICE Documents app for iOS Overview Changelog Manage files Open or create new files and folders Share files and folders Document Editor Basic operations Navigate through your document Select, cut, copy, paste text Undo/redo your actions Handwriting recognition Page formatting Set page parameters Insert page breaks Insert section breaks Insert footnotes and endnotes Insert page numbers Add hyphenation Paragraph formatting Align your text in a paragraph Apply formatting presets Select background color for a paragraph Change paragraph indents Set paragraph line spacing Insert line breaks Create lists Text formatting Set font type, size, and color Apply font decoration styles Add hyperlinks Operations on objects Insert tables Insert autoshapes Insert images Adjust chart settings Change text wrapping Manipulate objects Fillable forms Filling out a form Tools and settings View document information Change application settings Use the Find and Replace function Save/export/print your document Protect documents with a password Spreadsheet Editor Basic operations Navigate through your spreadsheet Select, cut, copy, paste data Undo/redo your actions Operations with sheets Create or delete sheets Manage existing sheets Cell text formatting Set font type, size, and color Add hyperlinks Editing cell properties Select cell background color Add cell borders Apply cell style Align data in cells Wrap text in a cell Merge cells Change number format Apply table styles Editing rows/columns Manage data in rows/columns Add or remove rows/columns Hide or show rows/columns Resize rows/columns Sort and filter data Operations on objects Insert charts Insert images Insert formulas Insert autoshapes Manipulate objects Tools and settings View spreadsheet information Change application settings Use the Find and Replace function Set language and region Save/export/print your spreadsheet Protect spreadsheets with a password Presentation Editor Basic operations Mobile presentation viewer Navigate through your presentation Select, cut, copy, paste text and objects Undo/redo your actions Working with slides Manage slides Change presentation theme Change slide layout Apply transitions Change slide background Preview your presentation Text formatting Insert text Set font type, size, and color Apply font decoration styles Align your text in a text box Change text indents Set paragraph line spacing Create lists Add hyperlinks Operations on objects Insert tables Insert autoshapes Insert images Create charts Manipulate objects Tools and settings View presentation information Use the Find function Save and export your presentation Change application settings Print your presentation Protect presentations with a password ONLYOFFICE Documents for Android ONLYOFFICE Projects for iOS ONLYOFFICE Projects for Android ONLYOFFICE Web Editors Glossary Video FAQ General Technology Pricing Workspace Enterprise Edition Docs Enterprise Edition Docs Developer Edition ONLYOFFICE Groups Connectors Trial period Use the Find and Replace function operations with files Create a new document or open an existing one Create a new presentation or open an existing one Create a new spreadsheet or open an existing one Save, download, print your document Save, print, download your presentation Save, print, download your spreadsheet View document information View spreadsheet information More articles View presentation information Manage files Open or create new files and folders Share files and folders View document information Change application settings Use the Find and Replace function Save, export, print your document View spreadsheet information Change application settings Use the Find and Replace function Save, export, print your spreadsheet View presentation information Use the Find function Save and export your presentation Change application settings Print your presentation Protect documents with a password Protect spreadsheets with a password Protect presentations with a password Manage files Open or create new files and folders Share files and folders View document information Use the Find and Replace function Download and print your document View spreadsheet information Use the Find and Replace function Download and print your spreadsheet View presentation information Use the Find and Replace function Download your presentation Print your presentation Manage files Open or create new files and folders Share files and folders Use the Find and Replace function Change application settings Download and print your document View document information Macros settings Change spreadsheet settings Change application settings Download and print your spreadsheet View spreadsheet information Macros settings Use the Find and Replace function Change presentation settings Change application settings Download your presentation Print your presentation View presentation information Macros settings Manage files Open or create new files and folders Share files and folders Use the Find and Replace function Change application settings Download and print your document View document information Macros settings Use the Find and Replace function Change spreadsheet settings Change application settings Download and print your spreadsheet View spreadsheet information Macros settings Use the Find and Replace function Change presentation settings Change application settings Download your presentation Print your presentation View presentation information Macros settings Project documents search for text in a file Search and replace function Search and replace function Search and replace function Use the Find and Replace function Use the Find and Replace function Use the Find function Use the Find and Replace function Use the Find and Replace function More articles Use the Find and Replace function Use the Find and Replace function Use the Find and Replace function Use the Find and Replace function Use the Find and Replace function Use the Find and Replace function Use the Find and Replace function search tools Search and replace function Search and replace function Search and replace function Use the Find and Replace function Use the Find and Replace function Use the Find function Use the Find and Replace function Use the Find and Replace function More articles Use the Find and Replace function Use the Find and Replace function Use the Find and Replace function Use the Find and Replace function Use the Find and Replace function Use the Find and Replace function Use the Find and Replace function Search for certain text Tap the Search icon at the top toolbar to activate the Find panel. Enter your inquiry into the data entry field. Specify search parameters by tapping the Search Options icon on the left and selecting the necessary options: SEARCH IN - is used to search within the active Sheet only or the whole Workbook. Match Case - is used to find only the occurrences typed in the same case as your inquiry (e.g. if your inquiry is 'Editor' and this option is enabled, such words as 'editor' or 'EDITOR' etc. will not be found). Match Cell - is used to find only the cells that do not contain any other characters besides the ones specified in your inquiry (e.g. if your inquiry is '56' and this option is enabled, the cells containing such data as '0.56' or '156' etc. will not be found). Tap the Search caption next to the entry field - the first cell that contains the required characters will be selected. Use arrow buttons to navigate through the found occurrences towards the beginning of the worksheet (if you tap the icon) or towards the end of the worksheet (if you tap the icon) from the current position. Replace the found matches Tap the Search Options icon on the left. Tap the Find and Replace menu item - the Find panel will change. Enter the replacement text into the second data entry field. Use arrow buttons to navigate through the found occurrences and tap Replace to replace the currently selected occurrence. To replace all the found occurrences, hold the Replace caption next to the entry field until the menu with the Replace All option appears, then tap it. Exit the Find mode To close the Find panel, tap within the worksheet area. Power up your iOS Create, edit and view documents, spreadsheets and presentations of all popular formats You Might Also Like This: Close