The Excel Import filter allows you specify the range of cells to be imported when you draw a Table object and link to the Excel spreadsheet. Follow the steps below to do so.
- Draw a Table with the Table tool.
- Select the Link to External Data checkbox.
- Click OK.
- Browse to the Excel file.
- Click Open.
- Under the Range field, type in the range of cells you want to import, e.g. A1:F24
- Click OK.