To Replace Individual or Multiple Cells Inside a Fence
- Place a fence around the cells to replace.
-
Select the Replace Cells tool ().
- In the tool settings window, set Method to Replace.
- In the tool settings window, turn on Use Fence and choose the Inside option.
- Select the replacement cell.
-
Enter a data point.
If Mode is set to Single, all of the cells inside the fence are replaced.
If Mode is set to Global, all of the cells inside the fence and those cells outside the fence having the same name are replaced in groups; after you click Yes in the alert box to confirm the replacement of one group of cells, subsequent alert boxes appear until all of the cells in the fence and those cells of the same name outside of the fence are replaced.