Learning to use Excel worksheets like relational databases can help you save time, eliminating duplication when managing large projects. A relational database is useful because information resides in ...

Excel now supports IMPORTTEXT and IMPORTCSV functions that load external text and CSV files as dynamic arrays, making it ...

Excel documents come in the form of spreadsheets, also known as worksheets, made up of a collection of cells on a single sheet of data. The 2003 version of MS Excel gives you options for rotating – ...

If you're not using these worksheet-related tricks, you're working harder than you have to! Susan Harkins shares five of her favorites. We all have features and commands that we use more than others.

Q. Some of my Excel spreadsheets contain many worksheets—up to 36 in some cases. But not all the worksheet tabs show at the bottom of the screen. Is there some way to make more tabs visible, such as ...

To help readers follow the instructions in this article, we used two different typefaces: Boldface type is used to identify the names of icons, agendas and URLs. Sans serif type indicates the names of ...