How to convert a Table to a Range

How to convert a Table to a Range

1    1.  Open Microsoft Excel

2    2. Open excel sheet having a table.

1   3.  Click any cell in the table. Tables Tools (Design) menu appears in the menu bar.

    4.   Click “Design”

    5.  Table Design ribbon appears.

3  6.  Click “Convert to Range” under Tools

1  7.  Click “Yes”

1  8.  Now you can see heading without filter. Your reference is created.