Find and Replace

Another option in editing cells is the Find and Replace option activated by pressing, when you are in a table, CTRL/CMD+F, or by right clicking on a cell and selecting the option Find/Replace. In both cases a line appears at the bottom of the table with two boxes (figure below); the left box (marked in red) is used to define the term you intend to find; the right box (marked in green) is used to define the term to be replaced with. By pressing the Find Next key the term specified in the first box is highlighted in the table; now you can either replace such term by pressing the Replace Selected key, or skip it and move to the next by pressing Find Next. Once you have moved to the next term in the table, you cannot go to a previous term. In that case you will have to manually select a previous cell to start from and continue searching.

Find and Replace

Figure 5.12. Find and Replace