1. Computing

Excel Tips

This list of Excel tips is covers how to carry out a variety of tasks in Excel. Many of the tutorials cover how to use basic features that are often overlooked. Each of these tips includes a step by step example.

Six Time Saving Tips in Excel
Here is a list of six tips that will save you time and effort when working with your Excel spreadsheets.

Excel Undo - Undoing Accidental Changes to a Spreadsheet
This tutorial shows you how to use Excel's Undo feature to quickly get back accidentally deleted data or reverse other changes made to a spreadsheet. This tutorial includes a step by step example of using Excel's Undo feature to reverse accidental changes to a spreadsheet.

Excel Redo - Reapplying Changes after Using Undo
This tutorial covers using Excel's Redo feature to reapply changes to a spreadsheet after they have been removed using Undo. This tutorial includes a step by step example of using Excel's Redo to reapply changes to a spreadsheet after removing them with Undo.

Insert Rows to Excel Worksheets
This tutorial shows you how, with a click of the mouse, you can easily add rows to an Excel worksheet.

Excel Copy and Paste
How to copy and paste in Excel. This tutorial includes a step by step example of using copy and paste in Excel.

Excel Cut and Paste
How to move data using cut and paste in Excel.

Excel Paste Link
Using paste link in Excel to have data automatically update in the destination cell(s) when the source data is changed.

Convert Text to Numbers with Excel Paste Special
Use Paste Special in Excel to convert values from text to numbers so they can be used in calculations.

Customizing Excel Auto Fill
Auto Fill is a very handy feature in Excel. It allows you to quickly add commonly used data to your spreadsheets. This article will show you how easily you can customize the lists of data that can be added.

Fill Down with the Fill Handle in Excel
Every one knows that the Fill Handle can be used to copy formulas in Excel, but did you know that it can be done with a double click of the mouse? This tutorial includes a step by step example of how to fill down a column of formulas in Excel by double clicking on the Fill Handle.

Adding Pre-Set Data with the Fill Handle
The fill handle can be used to add lists of preset data to a spreadsheet. This article covers the steps to follow to use the fill handle to add the days of the week or months of the year in Excel 2007.

Excel's Go To Feature
The Go To feature in Excel can be used to navigate to different cells in a spreadsheet. This article includes an example of how to use the Go To feature to move to different cells.

Turn Off AutoComplete in Excel
This quick tip shows you how to turn off AutoComplete in Excel.

Rename a Worksheet in Excel
If you rename a worksheet in Excel it can make it easier to keep data organized and easier to understand formulas. This tutorial includes a step by step example of how to rename a worksheet in Excel.

How to Change the Worksheet Tab Color
This tip covers how to change the worksheet tab color in Excel. This tip includes an example of how to change the worksheet tab color in Excel.

Excel 2007 Options Button
This tutorial covers where to find the Options feature in Excel 2007.

Microsoft Office 2007 Diagnostics
Microsoft Office 2007 Diagnostics is a group of tests that can be used to help correct problems with Microsoft Office files. The diagnostic tests can correct certain problems 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.

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

In Excel 2007 the "ribbon", which has replaced the menus and toolbars found...
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.

Limit Rows and Columns in Excel - Temporarily
This tutorial shows you how to temporarily limit the number of rows and columns that can be used in an Excel worksheet. This tutorial includes a step by step example of how to temporarily limit the number of rows and columns that can be used in an Excel worksheet.

How to Use the Excel Clipboard
This article shows you how to use the clipboard in Excel to simplify re-entering frequently used data.

Save Excel 2010 Files as PDF Files
Save Excel spreadsheets as PDF files in Excel 2010. This tutorial shows you how to save Excel spreadsheets as PDF files in Excel 2010.

Convert Excel 2010 Files to PDF Format Using the Share Option
Convert Excel files to PDF format in Excel 2010 using the Share Option. This tutorial shows you how to convert Excel files to PDF format in Excel 2010 using the Share option.

Convert Excel 2010 Files to PDF Format Using the Email Option
Convert Excel files to PDF format in Excel 2010 using the Email option. This tutorial shows you how to convert Excel files to PDF format in Excel 2010 using the Email option.

How to Undo Changes in Excel
This tip shows you how to undo accidental or unintended changes made to an Excel worksheet.

©2014 About.com. All rights reserved.