bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Online and Web > Online Collaboration > Filtering Web Discussions

Filtering Web Discussions

Summary: If you use the Web discussion capabilities available in some versions of Excel, you may want to filter the discussion comments you view. This is done by using the controls built into the Discussions toolbar. (This tip works with Microsoft Excel 2000, Excel 2002, and Excel 2003.)

If you work in an active office and you are using the Web discussion capabilities available in Excel 2000, Excel 2002, and Excel 2003, you may notice that there could be many, many comments in a workbook discussion. You can filter comments to help make your review of information more manageable. For instance, you can specify that you only want to see comments created by a specific person, or that you want to only see comments that occurred within a particular timeframe. You can filter discussions in this manner:

  1. Click on the Discussions tool on the Discussions toolbar.
  2. Choose Filter Discussions on the resulting menu. Excel displays the Filter Discussions dialog box.
  3. Use the Created By drop-down list to select the name of the person whose comments you want to see.
  4. Use the Creation Time drop-down list to indicate the time range for the comments you want to see.
  5. Click on OK.

Tip #2438 applies to Microsoft Excel versions: 2000 | 2002 | 2003


Remove Some Stress at Tax Time! Doing your personal income taxes can be a royal pain. Why not make the process just a bit less stressful with our 101-question checklist. You can prepare for filing your taxes with confidence, knowing you've covered all your bases.
 
Check out Filing Your Income Taxes Checklist today!

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)