Skip to main content

TIP - 40 : Find - Format as well via Find and Replace


Find - Format as well via Find and Replace

Where with Find and replace, we can also search and select the formatted cells.

How to use -

Step 1: Use Ctrl + F keyboard short cut or select find from Home tab

Step 2: Then click on options,

Step 3: Again, click on the Format which show a dialogue box Find Format from which you select the parameters of your choice or you can select an option “Choose Format From cell” which helps to find the exact replicate of cells

Step 4: Then click on Find All or Find next based on your choice

Comments

Post a Comment

Popular posts from this blog

Report Publishing via Pivot Table in different sheets

Report Publishing via Pivot Table in different sheets This feature is mostly helpful to publish the data in sheet wise Step 1: Create pivot table with Report filter , go to analysis tab or Options tab from "PivotTable options" Step 2: Click on options drop down Step 3: Then click on  “Show report filter pages” Now we can see the new excel sheet tabs names along with data, published based on the report filtered data.
Post a Comment
Read more