Some times when we need to select similar format cells for analysis purpose or for editing the cells.
To do this, there is a simple process as shown below:
1. Press "Ctrl + F"
2. Press "Options>>"
3. Click the arrow to the right of “Format” button (located at the right of the “Find what:” text box)
4. Select “Choose Format From Cell” (you can do it manually by using “Format” option instead)
5. Select the cell with the target format to select. The format is previewed at the right of “Find what:” text box
6. Press “Find All”. All the cells with the selected format are shown in the pane
7. Pick cells individually or press CTRL to select more than one to do the required action: replace, find, etc
One important thing to keep in mind while doing this is, in order to use the find and replace command you have to select "clear find format".
Hopes this topics provided what you're seeking.
No comments:
Post a Comment