Exceljet

Quick, clean, and to the point

Excel tips: lists

These videos come from our Excel video training.
Tip: How to select visible cells only
In this video, we'll show how to select visible cells only. This is useful when you've hidden rows or columns and want to work only with cells that are actually visible.
Run time: 2:35
Tip: How to display the number of items in a filtered list
In this video, we show you how to add a message at the top of a filtered list that displays total and visible items in the list.
Run time: 3:15
Tip: How to highlight rows with conditional formatting
In this Exceljet tip, we show you how to highlight entire rows in a list using conditional formatting with a formula. This is a handy way to visually expose information you are interested...
Run time: 2:53
Tip: How to quickly remove rows with empty values (Win)
In this tip, we look at a cool way to remove rows from a big list or table that contain empty values.
Run time: 2:29
Tip: How to quickly remove rows with empty values (Mac)
In this tip, we look at a cool way to remove rows from a big list or table that contain empty values.
Run time: 2:17
Tip: How to quickly remove blank rows (mac)
A really fast way to delete blank rows, even hundreds or thousands of blank rows, in record time. Excel does all the hard work for you.
Run time: 2:15
Tip: How to quickly remove blank rows (win)
A cool way to delete blank rows, even hundreds or thousands of blank rows, in record time. Excel does all the hard work for you.
Run time: 2:17
Tip: How to move around big lists fast
A handy shortcut for hopping around large lists or tables. Much faster than scrolling.
Run time: 2:37