Tame your computer – fancy filtering

21 Jan

Do you use dates in Excel? If so, you have probably at some point needed to display only those containing relevant information.

For example, you might want to filter out all deliveries you are expecting in February. Or all courses planned for March. You can obviously use Excel’s Find functionality (CTRL + F) to find a specific date. Or perhaps you use the Date Filters and select, say, Next Month. But did you know you can use the table’s Search functionality?

Here’s how:

1.       If necessary, create a table. (CTRL + T or CTRL + L, anyone?)

2.       Click on the drop-down arrow of the date’s column header.

3.       Click in the Search box and type (part of) your search term. For example, Feb.

4.       Press ENTER.

And no, this isn’t relying on you having entered your dates as, say, 16 February 2017. As long as the entries have been formatted as dates, this should work. And remember, there is no need to type the current year if the date you want to enter is part of this year. Simply type, say 16/2.  Perhaps have another look at tip 442.

Related tips:
Tip 358: Enter the current date and/or time into a worksheet  (http://roem.co.uk/tip_358.php)
Tip 426: Fast filtering (http://www.roem.co.uk/tip_426.php)
Tip 429: Quickly format and enable filtering of your data (http://roem.co.uk/tip_429.php)
Tip 442: Save time entering dates (http://roem.co.uk/tip_442.php)
Tip 474: Filter data in a PivotTable and PivotChart using Slicers (http://roem.co.uk/tip_474.php)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: