Title photo

Where I'm always right and no one can argue with me.

home > 2012 > 01 > 09

  • Mon
  • |
  • 09
  • Jan
  • 2012

How to define/name a range in Excel 2010

Here is today's tip. For me this comes up all the time when I do mail merges using an Excel file for the address data and a Word document for the actual letters.

In Excel 2010 I couldn't find the command I was used to finding under the "Insert" menu in earlier versions of Excel (pre-"ribbon").

I found these instructions online which told me exactly how to do it. (Of course, you have to customize a special sub-menu - why not? Thanks, Microsoft, once again.)

I thought I would pass this on to my many many many readers. ;)