Hyperlinks have been around for a long time, but some Excel users just don’t use them. One way your users can put them to good use is to create a simple table of contents sheet.

Try creating a table of contents. It makes it easy to find specific sheets, especially if your Excel file contains hundreds of them. Unfortunately, Excel doesn't have a one-click feature for ...

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 ...

Learn how to create Excel Pivot Tables in this comprehensive beginner's guide taking you through the process step-by-step. Spreadsheets can Skip to main content ...

A pivot table won’t always be adequate, but unless you must identify each subset’s latest entry within the context of all the records, the pivot table just might be the quickest and easiest ...

One way to make these multiple tables is to copy a table, pasting it elsewhere and then changing the new table's contents. Yet Excel can also copy formatting styles without copying cell contents ...