Want to organize all the worksheets in your Excel workbook? Try creating a table of contents. It makes it easy to find ...

Click "OK" and Excel adds a new hyperlink to cell A1 in the Table of Contents worksheet. This hyperlink's name matches the name you typed in the "Text to Display" text box. Click cell "A2" and ...

Create an Excel table in two seconds In addition, notice that the filter feature is automatically applied, so sorting by a specific field is accomplished by a few clicks of the mouse. 6.