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.

You’re probably familiar with selection shortcuts in Microsoft Excel. There are several that select text, sentences, whole paragraphs, and so on, so it should come as no big surprise that ...

A pivot table is a must-have tool for power Excel users. It lets you see the bigger picture, where you can make sense of large amounts of information quickly and easily. If you are still of two minds ...

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. All you need is one common, unique field. Here's how to set it up with multiple spreadsheets.

Just like in Excel for Windows, deleting a pivot table from Excel for the web is simply a matter of selecting the table and pressing the Delete key on your keyboard. Be sure to select all the ...

Here's how you can clear the formatting of your Excel table and revert it to the default style: Click on a cell in your formatted table. Select the Table Design tab that appears on the ribbon.

Select cells E3:L16. Go to Data, click the dropdown arrow next to What-if Analysis within the Forecast group, and choose Data Table. The Data Table window will open, asking for inputs into Row input ...