In the Excel worksheet, select the upper-left corner of the worksheet area where you want to paste the table. Press CRL plus V to paste the table into the worksheet. Why you just deleted the entire table? Because you can no longer access the column headings or the values in it. (you can't delete a row and columns at the same time) How can I make a table of contents from Microsoft Word, Excel and Access. Use the following method in Excel or Access to create a copy of your text table. For Excel, scroll down to the “Row or Column headings...” section. In the “Select Data Type...” dialog box type in “Text” and then select the column you are copying. Under “Row or Column List...”, select the column you are copying and select “Excel” from the drop-down list. Click “OK.” Under “Row or Column List...”, select the column that you are copying from Access. Click “OK.” How to Create a Table of Contents for Excel — How to Create a Table of Contents — Microsoft MSN In Excel, open the sheet you created in Step 1 of the article. Select the rows and columns that you want to enter as the table header for this list. Select the entire column and press Control-H to select it as a cell. Move the cursor to the cell. Press CTRL+C. In the new cell, select the row and column headings that you want to create a table of contents for. Press Control-P, then, Control-F to insert the table of contents. For more information on this method, visit “Excel Tables of Contents.” Or, see the following articles: For more help converting a table of contents to an Excel worksheet, contact Word or Access. Microsoft Word Table of Contents Generator in Excel — How to Create a Table of Contents in Microsoft Word — MSN In Excel, the table of contents looks like this: A Table of Contents for Excel in the Microsoft Office Suite — Google Spreadsheet In the text editing box, type in the following: Title = Text to be added. Text = A complete line of text. Number of Columns = The number of columns. Row Number of rows. Column Number of columns to be created. (If necessary, adjust the number to your needs.