Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro.

How to Format a Row Based on the Value of a Cell in Excel 2007. Microsoft Excel 2007's conditional formatting feature allows you to format cells based on certain criteria. As an example, you might ...

How to Set the Default Cell Value in Excel 2007. Microsoft Excel allows the entry, storage and organization of a large amount of data to be user-friendly. However, when entering data, you may not ...

Rows in an Excel worksheet can be repeated a specified number of times with user-defined functions. The Selection.insert command can be used to insert rows in an Excel sheet and there is no need to ...

Adding color creates a great visual effect, but did you know that you can evaluate values by color? Use this technique to turn color into valuable information.