How Do You Create a Header Row & Description Row in an Excel Spreadsheet?. Your Excel 2013 spreadsheets can benefit from page headers and fixed column titles, also called description rows.

Take advantage of relative cell references to add the same values to two different rows in Excel. Relative cell references create relationships between cells so that values entered in one cell are ...

Learn how to dynamically insert blank rows in Excel to improve data readability, organization, and clarity with advanced techniques.

I have a script that reads a couple lines of data from a spreadsheet but it doesn't close the excel process when the script completes. Anyone know how to do that?

I've been doing it from a web application (VBScript) with a DTS package for a couple years, but every damn time I have to add a field, I go to h3ll and back trying to get it to work again. In ...

How do you set up a worksheet with alternating colored rows like the traditional columnar pad design? There are many ways, but the easiest, for both Excel 2003 and 2007 is with a Conditional ...