Multiple Entries in an Excel Filtered List

Ctrl key to the rescue

When a list is filtered you are only seeing the rows that match the filter. The other rows are still there, just hidden. If you want to make the same entry in a group of filtered cells you can’t use the fill handle to drag and copy as you will overwrite the hidden rows. There is an easy way to do it.

Entering Dates in Excel

Stop the full stop

There are only two characters Excel recognises when separating numeric days, months and years in dates. They are the / and – characters.

Please don’t use the full stop as Excel won’t recognise it as a date.

Below you can see examples of using / and – in dates.

 

When you use the full stop Excel won’t recognise it as a date – see below.

Its left aligned and will be treated a text.

Related Posts

Unique Entries in Excel via a Conditional Format

Filtering to the rescue

Excel’s Conditional Formatting feature has a built-in unique option. Its unique option only identifies entries that are not repeated. This is different to the Advanced Filter Unique option which lists each unique item from a range once. To filter by entries only appearing once you can use Conditional Formatting with filtering. No formulas required.