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.