Whole-column references in Excel are silent performance killers, often forcing the program to manage a range of over a ...

The default method for including a column reference in an Excel formula is to use the column letter, a convention that may make it difficult to interpret the parts of complex formulas. Microsoft ...

Regular users of Microsoft Excel know about Workbooks and Worksheets, but do they know the differences? You see, many people confuse the terms Workbooks and Worksheets more often than not, and that is ...

The author of a Microsoft Excel 2010 workbook represents the owner of the document. When someone views the workbook properties through the Document Properties or Info panels, the author is one of the ...

Use index sheets to quickly navigate in an Excel workbook Your email has been sent Navigating through dozens of sheet name tabs in Microsoft Excel to find the one you need can be quite time consuming.

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