How would you like to MASTER graphic design by next week?
Click here to find out how
Featured Photoshop templates - professional ready to use designs for your next project
View all templates
Excel Formatting Tutorials
We hope that you will enjoy our Excel Formatting tutorials. Feel free to contact us if you would like to be a tutorial hero and contribute your own Excel Formatting tutorial to our site. Thank you !
Refining Excel Worksheet
This tutorial describes how to move, delete, and rename worksheets, as well as protect them from being edited or altered.
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.
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.
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.
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.
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.
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.
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.
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.
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.
The easiest and fairest way to do this is to use Excel's RAND function in combination with its sorting capabilities.
Sort by More Than Three Columns
Excel's Sort feature is limited in that it enables you to nominate no more than three data fields by which to sort.
Create 3-D Effects in Tables or Cells
It is easy to create this illusion yourself by applying formatting to a cell or range of cells.
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.
Identify Named Ranges on a Worksheet
Here is quick method you can use to identify the referenced ranges for each named range.
Total Tutorials in Category: 116