Entering & Editing Data in Excel 2007

Sorted by:  

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…]

How to Import Online Data into Excel 2007 with a Web Query

In Excel 2007, you can use Web queries to import data directly from various Web pages that contain financial and other types of statistical data that you need to work with in a worksheet. To create a new [more…]

How to Add Records to an Excel 2007 Table

After you’ve created an Excel 2007 table (using the Table button on the Insert tab), you can choose from several methods for adding records to the table. Before you add records, the range must already [more…]

How to Insert Symbols and Special Characters in Excel 2007

Excel 2007 makes it easy to enter symbols, such as foreign currency indicators, as well as special characters, like trademark and copyright symbols, into Excel's cells. These symbols are available in the [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…]

Selecting Cells in Excel 2007

Before you can enter your worksheet data in Microsoft Office Excel 2007, you must know how to select cells in a worksheet. The cell cursor is a black border that surrounds the active cell [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…]

Speeding Data Entry with Excel 2007's AutoFill Feature

Use the AutoFill feature in Microsoft Office Excel 2007 to quickly create a series of entries based on the data you enter in one or two cells. Excel 2007's AutoFill works with days of the week, months [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…]

Tips and Tricks for Entering Data in Excel 2007

When you're ready to enter data to a worksheet in a Microsoft Excel 2007 workbook, there are a few simple guidelines (a kind of data-entry etiquette) that you should keep in mind: [more…]

How to Use Custom Lists with Excel 2007's AutoFill Feature

In Excel 2007, you can create a custom series of names, locations, or other items that you use frequently and then use the AutoFill handle to automatically fill these list items in order in a workbook. [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