Want to organize all the worksheets in your Excel workbook? Try creating a table of contents. It makes it easy to find specific sheets, especially if your Excel file contains hundreds of them ...

Show users how to create a quick table of contents in Excel using the power of hyperlinks. Hyperlinks have been around for a long time, but some Excel users just don’t use them.

How to Randomize the Contents of a Column in Excel. Suppose you have an Excel spreadsheet with a single column A and 52 rows. The value in each row's cell represents a playing card, for example K ...

In the January column (page 82) a reader asked how to display 36 workbook tabs in Excel. We described several solutions, but reader Mary Jo Gruber, a CPA with a St. Louis public school district, ...

To display specific values in a PivotTable in Microsoft Excel, use one of the many built-in filters, such as Top 10.