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.

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

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.

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

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

Learn how to show formulas in cells instead of values or calculated results In Microsoft Excel. You can show or hide formulas in Excel cells.

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