Search format in excel

newexcler

New Member
Joined
Nov 15, 2015
Messages
39
Hi Experts,
Excel version: Professional Plus 2016
I thought searching for particular font is easy as to click on the Format and let excel choose the format or I find the format and ask excel to search.
but no, I have stuff copied from site to do some analysis. It has two columns, first is Type and and second is category but a few categories got in the category list.

The categories are in the font: Calibri Light (Heading) and others are Calibri Body.

The search for Calibri Light Heading does says nothing found. I have ensured, I do not select Font Style and Size as per the format type I find and I also used choose format from cell
Option to select (Unfortunately, they are hyperlinks and I have another question why remove hyperlinks doesn't remove them, may be separate question).

Any help would be appreciated.
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

jorismoerings

Well-known Member
Joined
Jul 4, 2014
Messages
1,482
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
Hi,

Try this:
  1. start a search by clicking "Find & Select" or shortcut Ctrl-F (a window will open)
  2. enter an asterisk (wildcard) into "Find what"
  3. click on the Format button ( a new window will open)
  4. select the font tab
  5. on the font tab select the font you're looking for
  6. confirm the font with OK (window will close)
  7. confirm the find with either "Find Next" or "Find all"
Hope this helps
 
Solution

newexcler

New Member
Joined
Nov 15, 2015
Messages
39
Hi,

Try this:
  1. start a search by clicking "Find & Select" or shortcut Ctrl-F (a window will open)
  2. enter an asterisk (wildcard) into "Find what"
  3. click on the Format button ( a new window will open)
  4. select the font tab
  5. on the font tab select the font you're looking for
  6. confirm the font with OK (window will close)
  7. confirm the find with either "Find Next" or "Find all"
Hope this helps
Hi Jorismoerings,
I did that, I could get only the first field in search, and no matter how many times I clean started the above process, excel said no matches found. When 3rd line has the format, I am searching. It is probably to do with the application data copied. I would usually trust "Remove Hyperlinks" to clean up for me but this made me realize, that is not the case. Anyway, I used workarounds esp used Power Query and transformations.
 

Forum statistics

Threads
1,144,574
Messages
5,725,076
Members
422,590
Latest member
Mikeyyy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top