ONLYOFFICE · Editing · Beginner
Find and Replace the Intended Cells in ONLYOFFICE
Limit replacement to intended cells and verify exact matches, case, near-matching IDs and formula results.
Quick answer
Open Find and replace, set an explicit specific range, and inspect case and entire-cell matching before replacing anything. Replace one match, verify its address and contents, then continue. Protect nearby prose, longer IDs and formulas with deliberate scope.
Replacing a short code everywhere can alter longer codes, prose or formulas. A safer workflow fixes the search scope first, previews the matches, replaces one occurrence and verifies it before any bulk action. This exercise includes near-matches that must survive unchanged.
Before you begin
Use a new local spreadsheet in ONLYOFFICE Desktop Editors, with only one sheet tab selected. The instructions use the English interface and ordinary cell ranges, not formatted tables. Formula examples use English function names and commas; if your configured formula language or separator differs, use the editor’s function dialog rather than changing the data to text.
Scope and evidence: ONLYOFFICE Desktop Editors 10.0.0; local workbooks (XLSX masters and ODS exchange copies) on Windows/Linux. Documentation-qualified workflow, checked against current English help on 2026-10-19; no native execution or exact OS/build verification. macOS, hosted collaboration and receiving-program fidelity are not tested. The desktop changelog identifies 10.0.0, released October 13, 2026. The desktop overview establishes the local-file product and supported operating systems. The feature help linked below is rolling documentation, not a frozen 10.0.0 manual. Expected results here are independently calculated practice checks, not observations of a running application. No screenshots are presented as current native evidence.
Create a deliberately ambiguous fixture
Rename the active sheet Codes. Enter this ordinary range, using the quoted formula exactly in B6:
| Cell | Input |
|---|---|
| A1 | ID |
| B1 | Status |
| C1 | Note |
| A2 | P-1 |
| B2 | Open |
| C2 | Open case |
| A3 | P-10 |
| B3 | Open |
| C3 | Reopened |
| A4 | P-11 |
| B4 | Closed |
| C4 | Open |
| A5 | P-2 |
| B5 | open |
| C5 | No change |
| A6 | P-3 |
| B6 | ="Open" |
| C6 | Formula result |
The intended edits are only Codes!B2 and B3, changing the literal status Open to Queued. B5 has different case; B6 is a formula; C2 and C4 are unrelated notes. A2 and A3 also demonstrate why partial-ID replacement is risky.
Save this starting workbook as oo-find-start.xlsx. Keep working in the same session for the Undo exercise below.
Inspect the scope before replacing
- On
Codes, open Find and replace using Ctrl+H on Windows/Linux or the Search panel’s advanced control. - Set Within to Specific range, then set its data range to
Codes!$B$2:$B$5. Use the range selector if the field requires that form in your interface. - Set Look in to Value, enable Case sensitive and Entire cell contents, and search for
Open. - Preview the listed matches. There must be exactly two: B2 and B3. Do not proceed if B5, B6 or a cell in column C appears. Selecting cells before opening the dialog is not a substitute for checking its explicit scope.
- Enter
Queuedin Replace with. Navigate to B2, replace that one occurrence, and inspect the worksheet. B2 should now be Queued while B3 remains Open. - Replace the remaining matched B3 occurrence. There are now zero
Openmatches under the same settings. Search forQueuedin the same range to confirm exactly B2 and B3.
For this small fixture, two deliberate replacements are safer than Replace All. For a larger real range, use Replace All only after the preview count and addresses match the expected edit set; record the count and inspect representative first/last records afterward.
Distinguish a formula from its result
Change the search scope to the single cell Codes!$B$6, keep Entire cell contents enabled, and search Values for Open. Its displayed result should match. Switch Look in to Formulas: the full underlying expression is ="Open", so searching the entire cell for just Open should no longer match. Search Formulas for the full ="Open" instead and inspect the formula bar. Make no replacement in this step.
This distinction matters because finding a displayed result does not authorize rewriting its formula. For calculations, locate the formula and review its inputs rather than replacing a number because it happens to appear in the result.
Practice a safe mistake and recovery
Close the search panel. In Codes!B4 type Queued accidentally, then immediately use the toolbar Undo once, before any other edit. Check B4 is Closed again and B2:B3 remain Queued. This Undo occurs in the current editing session before the final save/reopen, not across a reopened file.
For a near-ID check, search the specific range Codes!$A$2:$A$6 for P-1. With Entire cell contents enabled only A2 should match; with it disabled A2, A3 and A4 should match. Do not replace any IDs. Restore Entire cell contents before leaving the dialog.
Save and verify the final state
Save as oo-find-final.xlsx, close it and reopen that exact file. Activate Codes. Verify A2:A6 remain P-1, P-10, P-11, P-2, P-3; B2:B6 are Queued, Queued, Closed, lowercase open and formula-produced Open. Confirm the five original notes are unchanged and B6 still contains ="Open".
Keep the final workbook. For a new practice attempt, open oo-find-start.xlsx and immediately save a separate oo-find-repeat.xlsx. Do not undo back into a previous session or overwrite the accepted result to reset the exercise.
Troubleshooting
Too many matches usually means Workbook/Sheet scope, partial-content search or case-insensitive matching. Zero matches can mean the wrong sheet/range, unexpected spaces, a different formula/result mode or changed case. Inspect one problematic cell in the formula bar before loosening all filters. A replacement count is not evidence that the correct cells changed: always check the near-matches and untouched notes too.