Another way to manually add a table of contents in Excel is by using the Hyperlink Function. In this method, you need to type all the names of your sheets and add hyperlink formulas to each one ...

Are you still putting your data in plain, old spreadsheets? Excel 2013 makes it easy to link tables, create reports and more.

In Microsoft Excel, hyperlinks can open a separate file or Web page. Clicking a link activates it, opening the destination in a new window. If your sheet contains multiple links, such as to ...

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.