Direct cell references in Excel link one cell to another using the ... As Table" in the Home tab on the ribbon. There, select the design that works best for you. Now, use the Create Table dialog ...

Alternatively, convert your formatted Excel table to an unformatted range by selecting one of the cells within the table, and clicking "Convert To Range") in the Tools group of the Table Design tab.

Open Excel and click the cell where you want the data to start. Go to the paste button on the top menu bar. Click the drop-down arrow on the paste button to reveal paste options. Paste text only ...