- Introduction
- Installation and authentication
- Getting started
- Sending and sharing files
- Working with files
- Using the file menu bar
- Open and create files
- Open a file from another app
- Editing files with Workspaces Editor
- Edit a file in BlackBerry Workspaces Editor
- Editing documents
- Editing spreadsheets
- Add, delete, and rename sheets in a spreadsheet
- Add, view, edit, and delete comments in a spreadsheet
- Change the font or cell format in a spreadsheet
- Clear the contents of a cell
- Cut, copy, and paste cells, rows, or columns in a spreadsheet
- Find and replace text in a spreadsheet
- Freeze and unfreeze panes in a spreadsheet
- Hide or show rows and columns in a spreadsheet
- Insert or delete a row or column in a spreadsheet
- Resize a row or column in a spreadsheet
- Editing presentations
- Save your changes to the workspace
- Working with comments
- Annotate files
- Search within files
- Locking and unlocking files
- Select multiple files
- Track file activities
- Acknowledge a file
- Favorite a file
- Managing workspaces, folders, and files
- Create a new workspace
- Create a workspace on an external repository
- Create a new folder
- Rename a workspace, folder, or file
- Share the link to a workspace, folder, or file
- Send a message
- Mark a workspace, folder or file as a favorite
- Select multiple files
- Move a folder or file
- View info
- View recent locations
- Managing access
- Managing notifications
- Working offline
- Managing your settings
- User roles and permissions
- Collaboration and recipient sign in
- Read acknowledgement
- BlackBerry Workspaces security
Find and replace text in a spreadsheet
You can find instances of text in the spreadsheet you are editing and
replace it with text that you specify.
- Tap
> Find. - In theFindfield, type the word or phrase that you want to find in the spreadsheet.
- To make your search case sensitive, tap.
Case sensitive - To search the entire workbook, tap.
Entire workbook - To search an entire cell, tap.
Entire cell
- To replace text, in theReplacefield, type the word or phrase that you want to replace the text that you typed in theFindfield.You can leave this field blank to remove instances of a word.
- Do any of the following:
- To find a word or phrase, or its next instance, tap
. - To replace the highlighted instance of a word or phrase, tapReplace.
- To replace all instances of a word or phrase, tapAll.
- When you are done, tap the back button on your device.