Try creating a table of contents. It makes it easy to find specific sheets, especially if your Excel file contains hundreds ...

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.

To create a search field in a spreadsheet, you must first activate the Developer tools menu. To do this, go to Options > ...

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

How to create a temporary view in Excel We may earn from vendors via affiliate links or sponsorships. This might affect product placement on our site, but not the content of our reviews.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends. Skip to main content Menu ...

The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...

2. Move The Legend. I don’t know why Excel positions the legend to the right of a chart by default. In most cases, it’s terribly awkward. I prefer to move the legend to the top or bottom of a ...

Chandoo's Excel Gantt chart combines a calendar and to-do list to display what has to be completed when in a good-looking table layout. If you don't want to set up the sheet yourself, download an ...