filtering

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Filtering

Filtering

resolvedResolved · Low Priority · Version 2007

Nicola has attended:
Excel Intermediate course

Filtering

Can excel filter characters other than letters/numbers?

RE: Filtering

Hi Nicola

Thanks for your question

The simple answer is yes. You can filter by any character that you can insert into a cell. The character will appear in the auto filter combo in the same way that letters and digits also do

Regards

Stephen

Wed 6 Jul 2011: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Editing Formulas in Excel Cells

Although people like to edit a formula in the Formula bar, you can also edit a formula in the cell.

To do this select the cell and press "F2". This puts Excel into Edit mode, and you can move around in the cell and make any necessary changes.

Double-clicking the cell also puts Excel in Edit mode.

View all Excel hints and tips


Server loaded in 0.07 secs.