Selecting a Column Range within a Merged Cell in Excel [video]

I am not a fan of the merged cell format. It causes more problems that it solves. One issue you will face is trying to select a single column range within a range that has a merged cell. Here is how you handle it.

This post is a video post as it easier to show the problem and the solution in a video.

One Minute to Excel #29 – Nine Names in a Minute

Shortcut to speed up name creation

In this short video I demonstrate how to create range names quickly based on labels. Range names are a powerful formula feature. I also demonstrate their use.

Begin challenging your own assumptions. Your assumptions are your windows on the world. Scrub them off once in a while, or the light won’t come in.

Alan Alda – commencement speech – 1980