My CALC file has 15 sheets.
I would liketo search in all 15 sheets for a particular value without having to initiate FIND or CTR-H for each sheet.
I tried FIND ALL on both the CTR-H and CRT-F. Neither do what I want.
Thank you,
⌡im [THE BookMan]
920.265.5966
Select [x] All sheets under the Find: field.
LO 7.1.7.2.
EDIT (2021-11-21): Also, you can select the tabs of the chosen sheets (all, in this case).
After testing a bit, I found this:
If you select Sheet1 and Sheet3 tabs, select some range (row 1 in the image), mark Current selection only and mark All sheets…
…the replacement will happen in the selected range but in Sheet2 also.
GEEEeeeeze !
How simple.
You guys have thought of everything. Maybe some day I’ll learn to read everything in the dialog box.
Thank you, ⌡im [THE BookMan]
920.265.5966
Especially Messi. 