Office challenge: How quickly can you count the number of cells in a selection?

This week test your Excel and math skills by sharing a quick method for determining the number of cells in a selection.

This week, there's no harried users, just a fun quiz in the hopes of exposing an interesting Excel feature that lots of users never even notice. Now, let's suppose you need to know the number of cells in the current selection (not a range, but a selection). What's the quickest way to do so? You don't have to return a value in an Excel cell; you just need to determine the correct number of cells.


Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

Editor's Picks