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

How to display Document Properties in Excel from Info settings Click the File tab on the ribbon. On the backstage view, click Info on the pane.

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

How to Show Duplicate Records in Excel. As your business grows, so too will the documents and spreadsheets that you use to help keep things running. Eventually, the spreadsheets may get so big ...