Q: The instructions say to edit the named range before importing. How do I do this?

A: Here are the instructions on how to set a named range:

1. Open the import spreadsheet in Excel.
2. Go to the "Formulas" tab on the ribbon and click "Name Manager".
3. At the bottom of the pop-up window, next to "refers to", click the up arrow.
4. Your spreadsheet should show a green dashed blinking line around the import area. If this area does not include your data, it will not be imported.

5. Select the correct area (including the column headers, even if there is no data below them), and close the pop-up window. Save the sheet and import again. Here is a short video showing how to edit the named range: https://youtu.be/aSGUYydy7WA

Tags: import from excel, named range.