What? Multiple values in a cell?

Excel will soon introduce support for multiple values within a cell. This will make a few tasks easier to achieve than they were before.

Here's a simple example:

Previously when you had several items within a cell, you would have to first create new columns for each item, if you wanted to filter them.

But now, you just select the column (like the Hobbies column below) and make it in to a 'List' (Insert tab, Controls group). Then you can filter away!

This feature is now in the 'Insider' version and will roll out to other versions over time.

< Older Post

Forgot to name your Table?

By Martin Healey • October 16, 2026

NEW! Naming your Table straight away I'm sure you've done this before: create a Table, go to refer to it in a function but only to realise that it's called Table1, Table2, etc. Then you have to decide whether to abandon your function writing and go and name your Table, or be lazy and leave it be. GOOD NEWS! Excel have just added the option of naming your Table when your first create it! If this new feature isn't yet in your version of Excel 365, then it will be soon :)

Stop using Enter!

By Martin Healey • October 9, 2026

The annoying thing about pressing Enter is that you end up at the next cell down; you then have to click back on the cell above to do what's next, e.g. making it bold, colouring it or filling across. So about using Control + Enter instead? This has the same effect as Enter, but you remain on the same cell. I use Control + Enter more than I do just Enter.