Identify Named Ranges on a Worksheet
Here is quick method you can use to identify the referenced ranges for each named range. Read more...
MS-Excel - General Formatting Tutorials
Dynamic Ranges for Maximum Flexibility
A dynamic named range that resides within another dynamic named range can be very useful for things such as long lists of names. Read more...
Fill All Blank Cells in a List
Many of Excel's functions are designed to be used on lists. For most of these functions to work correctly, lists should not contain any blank cells, and column headings should be formatted differently from the data in the list. Read more...
Address Data by Name
Although cell numbers are at the foundation of everything Excel does, it's much easier to remember names, such as Item Number and Quantity, than it is to remember cell numbers, such as A1:A100. Excel makes this easy. Read more...
Add a Custom List to the Fill Handle
Once you have created a few of your own Custom Lists, it can be hard to remember the first item in the list that must be entered in a cell. This tutorial adds the list to the Fill Handle. Read more...
Provide Decreasing Data Validation Lists
Wouldn't it be useful if you could give users a list of options to select that decreases as options are used? You can create this nifty feature with the use of Data Validation and some Excel VBA code. Read more...
Prevent Blanks/Missing Fields in a Table
You can easily manipulate the Data Validation feature of Excel to ensure that you have no blank cells within your list. Read more...
Enable Grouping and Outlining on a Protected Worksheet
In Excel 2000, Microsoft added many new levels of worksheet protection to Excel. Unfortunately, they neglected to add one that would allow Excel users to use Grouping and Outlining on a protected worksheet. Read more...
Create Custom Lists
By adding a custom list to Excel, you can type the first item in the list, drag it down using the fill handle, and watch the list fill automatically. Read more...
Add More Levels of Undo to Excel for Windows
With the tutorial in this section, you can change the registry so that you can undo up to 100 mistakes. Read more...