CREATE NAME #2: Mass-create multiple names based on worksheet labels

Dan Holme

October 30, 2007

1 Min Read
ITPro Today logo in a gray background | ITPro Today

If you have a "normal" worksheet, with descriptive labels around your data (column labels and/or row labels), you can create all the names you need:

  1. Select the data and labels.

  2. Choose Insert → Name ? Create.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like