Count Words in a Cell or Range of Cells
To get a word count of any cell or range of cells, we'll use a combination of SUBSTITUTE and LEN function/formulas. Read more...
MS-Excel Tutorials
Subcategoreis
Excel 2003 Functions and Formula General Formatting Getting Started
Identify Named Ranges on a Worksheet
Here is quick method you can use to identify the referenced ranges for each named range. Read more...
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...
Create Custom Functions Using Names
Although referencing data by name is convenient, it's sometimes more helpful to store a constant value or even a formula, especially if you've been creating custom functions in VBA. Read more...
Make Your Formulas Increment by Rows
Excel's automatic incrementing of cell references works well most of the time, but sometimes you might want to override how it works. 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...
Manipulate Data with the Advanced Filter
If you are familiar with Excel's AutoFilter tool, you also are familiar with its limitations. If you require extensive data manipulation, using Excel's Advanced Filter tool is the way to go. Read more...
Random Sorting
You can use Excel to pick three winners-1st, 2nd, and 3rd-chosen at random from a list in your spreadsheet. The easiest and fairest way to do this is to use Excel's RAND function in combination with its sorting capabilities. Read more...
