Excel Tutorials: How to use Excel 2007 Custom Header

For more Excel tips and tricks go to my static page:  Excel Tutorials and Tricks Series.


In Excel 2007, a header is a line of text that prints at the top of each page in the spreadsheet.

Excel Tutorials: How to Create a Template in Excel 2007

For more Excel tips and tricks go to my static page:  Excel Tutorials and Tricks Series.

A template in Excel is a spreadsheet file containing common data and formatting options that is used as a model for other spreadsheets.

• Formatting can include font and layout changes, conditional formatting, color changes, and any other available options.
  
  
• Charts can added to the template file as can formulas, functions, look up tables, and macros.

Steps to creating a template in Excel 2007

1. Enter all of the necessary data.
   
   
2. Add or remove rows and columns as needed.
   
   
3. Create formulas, charts and other

Excel Tutorials: How to Create a Formatting Style in Excel 2007

For more Excel tips and tricks go to my static page:  Excel Tutorials and Tricks Series.

A style in Excel 2007 is a combination of formatting options that is named and saved as part of your current spreadsheet file. The new style can then quickly be applied to data and cells in the spreadsheet.
Related article: Copy a Formatting Style in Excel 2007.

Excel Tutorials: How to Copy a Formatting Style in Excel 2007

A style in Excel 2007 is a combination of formatting options that is named and saved as part of your current workbook. Once created, this style can be copied and used on data and cells in other workbooks as well.
For more Excel tips and tricks go to my static page:  Excel Tutorials and Tricks Series.

Excel Tutorials: How to create and use Excel 2007 Macro

Excel Macro Recorder Tutorial

Excel 2007 Macro Recorder Tutorial

� Ted French

For more Excel tips and tricks go to my static page:  Excel Tutorials and Tricks Series. 

Excel Macro Recorder Tutorial

Excel Tutorials: How to Lock Cells and Protect Worksheet Data in Excel 2007

Protecting data from change in Excel is a two step process.

Excel Tutorials: How to use Goal Seek in Excel

Excel's Goal Seek feature allows you to alter the data used in a formula in order to find out what the results will be.

The different results can then be compared to find out which one best suits your requirements.

Excel Tutorials: How to Find Below Average Values with Conditional Formatting

Finding Below Average Values with Conditional Formatting

Adding conditional formatting to a cell in Excel allows you to apply different formatting options, such as color, to a cell or cells that meet certain conditions.

For more Excel tips and tricks go to my static page:  Excel Tutorials and Tricks Series.

Excel Tutorials: How to Find Above Average Values with Conditional Formatting

Finding Above Average Values with Conditional Formatting

Adding conditional formatting to a cell in Excel allows you to apply different formatting options, such as color, to a cell or cells that meet certain conditions.

For more Excel tips and tricks go to my static page:  Excel Tutorials and Tricks Series.

Excel Tutorials: How to Shade Rows with Conditional Formatting in Excel 2007

Shading Rows with Conditional Formatting in Excel

Conditional formatting can be used for shade alternate rows in a selected range of data. In large worksheets, shading alternate rows makes it easier to read data from left to right across the worksheet .

Excel Tutorials: How to Use Conditional Formatting Dates in Excel

Excel 2007 Conditional Formatting for a Date

For more Excel tips and tricks go to my static page:  Excel Tutorials and Tricks Series.

Excel Tutorials: How to Find Duplicate Data in Excel with Conditional Formatting

Find Duplicate Data in Excel with Conditional Formatting

(Use Conditional Formatting to find Duplicate Data in Excel)

It is easy to find a variety of duplicate data - formulas, numbers, dates, data records - in Excel 2007 using conditional formatting. The article includes an example of using conditional formatting in Excel 2007 to find duplicates.

  For more Excel tips and tricks go to my static page:  Excel Tutorials and Tricks Series.

Excel Tutorials: How to create Excel Freeze Panes Step by Step

Freeze Panes Overview

Lock Columns and Rows in Excel with Freeze Panes

© Ted French

For more Excel tips and tricks go to my static page:  Excel Tutorials and Tricks Series. 

Excel Tutorials: How to Creating a Drop Down List in Excel 2007

A drop down list allows you to enter data into an Excel spreadsheet from a preset list of entries. This can be done to make data entry easier or to limit the number of acceptable choices.

For more Excel tips and tricks go to my static page:  Excel Tutorials and Tricks Series.

Excel Tutorials: How to Sort Data in Excel 2007

For more Excel tips and tricks go to my static page:  Excel Tutorials and Tricks Series.

Excel's sort feature is a quick and easy way to sort data in a spreadsheet. The options for sorting your data include:

Excel Tutorials: How to Sort Data by Font Color in Excel

Sort Data by Font Color in Excel

Sort By Font Color Excel 2007

© Ted French

For more Excel tips and tricks go to my static page:  Excel Tutorials and Tricks Series. 

Excel Tutorials: How to Sort Data by Cell Color in Excel 2007

Sort Data by Cell Color in Excel 2007

Sort By Cell Color Excel 2007

© Ted French

For more Excel tips and tricks go to my static page:  Excel Tutorials and Tricks Series. 
 

Excel sort options include a Custom Sort feature that allows you to sort data by the cell background color or by font color.
Sorting by color can be useful if you are using conditional formatting, which allows you to change the cell color or font color of data that meets certain conditions.
Sorting by color can then be used to group this data together for easy comparison and analysis.

Example: Sort by Cell Color in Excel

Note: For help with this example, see the image above.

1. Enter the following data into cells D1 to D6: 40, 20, 30, 60, 5, 25.
   
   
2. Use the mouse and CTRL key on the keyboard to select cells D1, D3, D5.
   
   
3. Click on the Home tab of the ribbon.
   
   
4. Click on the down arrow next to

Excel Tutorials: How to Sort By Multiple Columns of Data in Excel

In addition to performing a simple sort by one column of data, as covered in the article Sort Data in Excel 2007, Excel's custom sort feature allows you to sort multiple columns in a spreadsheet.

For more Excel tips and tricks go to my static page:  Excel Tutorials and Tricks Series.

Excel Tutorials: How to Sort by Date in Excel

 For more Excel tips and tricks go to my static page:  Excel Tutorials and Tricks Series.

 Using Excel's Date Sort Feature

In addition to sorting regular data in a spreadsheet, such as numbers or names, Excel's sort feature can also be used to sort by date.
Excel's sort options for dates include:

Excel Tutorials: How to use Excel 2007 Pivot Table Step by Step

Pivot Table Overview

Excel Pivot Table Tutorial

© Ted French

For more Excel tips and tricks go to my static page:  Excel Tutorials and Tricks Series.