Sorted by:  

Comparing Two Excel 2007 Worksheets Side by Side

You can use the View Side by Side command button on the View tab in Excel 2007 to quickly and easily do a side-by-side comparison of any two worksheet windows that you have open. When you click this button [more…]

Splitting Data into Multiple Columns in Excel 2007

Use the Convert Text to Columns Wizard in Excel 2007 when you need to split combined data into separate columns, such as a first name and last name; or city, state, and zip code. This type of combined [more…]

Using Paste Special in Excel 2007

Microsoft Office Excel 2007 normally copies all the information in the range of cells you select when you paste the data. Use Excel's Paste Special command to specify other options, such as pasting only [more…]

Inserting Cells, Rows, or Columns in Excel 2007

If you need to add new data within an existing Microsoft Office Excel 2007 worksheet, you can insert new cells, columns, or rows rather than going through all the trouble of moving and rearranging several [more…]

Deleting Cells and Data in Excel 2007

In Microsoft Office Excel 2007, when you need to delete data, remove formatting in a cell selection, or remove entire cells, rows, or columns, you have many options depending on your objective. Excel can [more…]

Using Drag and Drop in Excel 2007

Drag and drop is a mouse technique that you can use in Office Excel 2007 to pick up a cell selection and drop it into a new place on the worksheet. Although drag and drop is primarily a technique for moving [more…]

Advanced Find and Replace in Excel 2007

In addition to performing a basic find and replace operation in Microsoft Office Excel 2007, you can use advanced search options (in the expanded Find and Replace dialog box) to carry out a more detailed [more…]

Using (or Disabling) Excel 2007's AutoComplete Feature

The AutoComplete feature in Office Excel 2007 anticipates what you might want to enter next based upon text you just entered, thus reducing errors and speeding up your work. AutoComplete comes into play [more…]

How to Check Your Spelling in Excel 2007

Microsoft Office Excel 2007 includes a built-in spell checker that can catch and get rid of spelling errors and typos in your worksheets. Excel 2007's spell checker normally looks for misspellings only [more…]

Transposing Data in Excel 2007

While creating a Microsoft Office Excel 2007 worksheet, you may decide to change the data structure so that the row headings appear as column headings, or vice versa. Excel 2007 provides the Transpose [more…]

Finding and Replacing Data in Excel 2007

Excel 2007's Find and Replace feature can be a powerful tool. Use Find and Replace to locate — and optionally replace — text or values in a worksheet. You can narrow the search results by specifying formatting [more…]

Automatically Fix Typos and Add Text with Excel 2007's AutoCorrect Feature

Excel 2007's AutoCorrect feature already knows to automatically fix two initial capital letters in an entry, to capitalize the names of the days of the week, and to replace a set number of text entries [more…]

Editing Records in an Excel 2007 Table

As you work with Excel 2007 tables, you will often find the need to edit or delete records and perform routine maintenance on the table. You can edit the records manually in the worksheet or use a data [more…]

Using the Clipboard Task Pane in Excel 2007

The Office Clipboard can store multiple cuts and copies from any Office program running under Windows, not just Excel 2007. In Excel, this means that you can continue to paste stuff from the Office Clipboard [more…]

Using Undo and Redo in Excel 2007

The Undo feature in Office Excel 2007 can quickly correct mistakes that you make in a worksheet. The Redo button lets you "undo the undo." The Undo button appears next to the Save button on the Quick Access [more…]

Cutting, Copying, and Pasting in Excel 2007

You can use the Cut, Copy, and Paste commands to move or copy information in an Office Excel 2007 worksheet. These commands use the Office Clipboard as a kind of electronic halfway house where the information [more…]

Annotating with Text Boxes in Excel 2007

Text boxes in Excel 2007 are graphical boxes that you can use to add explanatory text or commentary to a worksheet or chart. Text boxes can be positioned wherever you like and can be formatted to match [more…]

Basic Data Editing in Excel 2007

When entering vast quantities of data in Microsoft Office Excel 2007, it’s easy for typos to creep into your work. How you correct mistakes in Excel 2007 depends upon whether you notice the error before [more…]

Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com