Microsoft Excel is a spreadsheet program used for analytical purposes. The program's files are known as workbooks. A workbook should contain at least one visible worksheet--a collection of cells ...

A macro to unhide all hidden sheets in an Excel workbook Your email has been sent Unhiding Excel sheets is easy, but can be tedious. Use this simple macro to unhide all hidden sheets in an Excel ...

Hiding lines, or rows, in Microsoft Office Excel 2010 is very simple: Right-click the lines and select "Hide." However, expanding the hidden lines in the Excel spreadsheet is not as simple. To get the ...

There are several tricks you can use to organize or otherwise clean up your spreadsheets across multiple apps, from automated calculations to setting up filters. In fact, it's often necessary (or at ...

Please note: This item is from our archives and was published in 2009. It is provided for historical reference. The content may be out of date and links may no longer function.

Excel won't display hidden data in a chart unless you flip the switch. Learn which option controls this behavior. By default, Excel displays only visible data in a chart. Consequently, if you hide ...

Microsoft Excel has hundreds of tools and functions, meaning it's quite easy to overlook some of the most useful ones. In this guide, I'll share four lesser-known, hidden tricks that could transform ...