QuickTips Index

Sort Data in Excel 2007
Using Excel 2007's sort feature. Step by step example of sorting data in Excel 2007.

Create a Template in Excel 2007
This tip shows you how to quickly create a template in Microsoft Office Excel 2007.

Protect Worksheet Data in Excel 2007 Step. 2
How to protect worksheet data in Excel step 2 - protect the worksheet. Includes a step by step example.

Protect Data in Excel 2007 Step 1
How to protect data in Excel part 1 - lock/unlock cells. This article includes a step by step example of how to lock cells in order to protect data in Excel 2007.

Copy Formulas with the Fill Handle
The fill handle can be used to copy formulas from one cell to other cells in the spreadsheet. This article covers the steps to follow to use the auto fill handle in Excel.

Create a Formatting Style in Excel 2007
This tip shows you how to quickly create a custom formatting style in Excel 2007.

Copy a Formatting Style in Excel 2007
This tip shows you how to quickly copy a custom formatting style from one workbook to another in Excel 2007.

Remove Duplicate Data Records in Excel 2007
This article shows you how to quickly search for and remove duplicate data in Excel 2007 databases and lists

Excel 2007 Paste Link
Using paste link in Excel 2007. Step by step example of using paste link in Excel 2007.

Move Data in Excel
How to move data from one cell to another in Excel 2007. Step by step example of moving data in Excel 2007.

Excel 2007 Copy and Paste
Using copy and paste in Excel 2007. Step by step example of using copy and paste in Excel 2007.

Scroll Through Ribbon Tabs in Excel 2007
In Excel 2007 you can scroll through the ribbon commands using the scroll wheel on the mouse.

Fixing Errors with Microsoft Office Diagnostics
Microsoft Office 2007 Diagnostics is a group of tests that can be used to help correct errors in Microsoft Office files. The diagnostic tests can correct certain errors directly and will give information on such things as your computer’s memory and hard drive, that can be used fix problems found on these devices.

Hide the Ribbon in Excel 2007
In Excel 2007 the "ribbon", which has replaced the menus and toolbars found in earlier versions of Excel, can quickly be hidden to give you more space in your spreadsheet.