Learn how to define, use & delete names in Excel formulas. It becomes easier to identify & comprehend data when you can add Names to it.

How to Rename a Worksheet in Microsoft Excel. Choosing to share or reuse a Microsoft Excel spreadsheet may be a time-saving business decision, whether you want to simply update information or ...

This formula shows how to reference the cell in another worksheet using a formula. Begin the formula with an equal sign, and follow it with the name of the worksheet you wish to reference.

Learn how you can make use of Name Box in Excel. The purpose of Excel Name Box is to help reduce the time taken while working with columns, cells, rows & ranges.

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.

The bare bones VBA code A simple list of sheet names is easy to generate using VBA thanks to the Worksheets collection. Listing A shows a simple For Each loop that cycles through this collection.

Use Editing, Fill, Justify to add instructions to your Excel 2007 worksheets When you need to add instructions to an Excel 2007 worksheet, they usually look something like Figure A.