Searching in the Board

Searching in the Board

It turns out that online help is not for wimps, nor is searching online help. The forums at MrExcel.com are not only interactive Q&A forums, but also serve as a searchable Database of problem/solution sets.

Knowing how to search for a problem/solution set might lead you to an array of potential solutions without even having to ask a question!

There are two main methods of searching the forums.

Google Search

It’s fast and robust. The trick is to make the search site specific, you can do this by adding site:mrexcel.com at the beginning of your search. Here’s the starting point:

And here are your ‘Advanced Search’ options:

And note, the domain is populated for you, here.

Google Search Tips:

  • If searching for phrases, include them in "double quotes"
  • Words that must be included in search results should be preceded by a + sign. eg +formula
  • Words that must be excluded from search results should be preceded by a - sign. eg -macro

Now, we’ll look at a few examples.

First, here’s a general Google search on the Forums, here, on conditional formatting, (this is how you would enter the search in the Google search bar):

  • site:mrexcel.com "conditional formatting" "more than 3 colors"

In this example, we have searched MrExcel.com for the phrases "conditional formatting" and "more than 3 colors". Click here to see the search results.

Second, we’ll look at a user-specific search. In Google, search on:

  • site:mrexcel.com NateO Byte Ubound

In this example, we have searched MrExcel.com for NateO, Byte and Ubound. Click here to see the search results.

Also note that signatures work as well, e.g., Nate Oliver is a viable search, as seen in the following example:

  • site:mrexcel.com Nate Oliver Byte Ubound

There are at least two possible limitations to this:

  • Google might not have cached a useful post, yet.
  • The search results don’t appear to be sorted, in any way, let alone by date. For this, we’ll turn to the built-in search functionality.

Built-in Forum Search

Click Search button on the top right corner of the page to make a search.

Or you can use Advanced Search for more options.

Once on that page you should find lots of options to help refine your search.


Sent by NateO (Legend) on Nov 20th, 2005

Watch MrExcel Video

This Week's Hot Topics

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