Entering & Editing Data in Excel 2010

View:  
Sorted by:  

Moving the Cell Cursor in Excel 2010 Spreadsheets

Excel 2010 offers a wide variety of keystrokes for moving the cell cursor to a new cell. When you use one of these keystrokes, the program automatically scrolls a new part of the worksheet into view, if [more…]

How to Use the Thesaurus in Excel 2010

Excel 2010 includes access to a thesaurus via the Research task pane if you need to find a word with a similar meaning to a word on your worksheet. Using the thesaurus is a simple process. [more…]

How to Use Excel 2010's Find and Replace Feature

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

Advanced Find and Replace in Excel 2010

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

How to Create a New Custom Dictionary in Excel 2010

In Excel 2010, you can create custom dictionaries to use when spell checking your worksheets. You use the Add to Dictionary button in the Spelling dialog box to add unknown words to a custom dictionary [more…]

How to Use Excel 2010's Research Task Pane

Excel 2010 includes the Research task pane that you can use to search for information using online resources, such as Bing, Encarta Dictionary, Thesaurus, and MSN Money Stock Quotes. Because these resources [more…]

How to Translate Text in Excel 2010

Microsoft Office Excel 2010 provides access to translation tools on the Research task pane that enable you to translate words or phrases using bilingual dictionaries. [more…]

Excel 2010's Three Data Types and Their Default Formats

In Excel 2010, the worksheet consists of a grid of columns and rows that form cells. You enter three types of data in cells: labels, values, and formulas. [more…]

Tips and Tricks for Entering Data in Excel 2010

When you're ready to add data to a worksheet in a Microsoft Excel 2010 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 2010's AutoFill Feature

In Excel 2010, you can use the AutoFill feature to create a custom list with names, locations, or other items and then use the AutoFill handle to fill these list items in order in a workbook. [more…]

Using (or Disabling) Excel 2010's AutoComplete Feature

The AutoComplete feature in Excel 2010 anticipates what you might want to enter next based upon text you previously entered. AutoComplete reduces errors and speeds up your work. The AutoComplete feature [more…]

How to Insert Symbols and Special Characters in Excel 2010

Excel 2010 makes it easy to enter symbols, such as foreign currency marks, as well as special characters, like trademark and copyright symbols, into cells. These symbols are available in the Symbol dialog [more…]

Basic Data Editing in Excel 2010

When entering vast quantities of data in Excel 2010, it's easy for typos to creep into your work. How you correct mistakes in Excel 2010 depends upon whether you notice the error before or after you complete [more…]

How to Cut, Copy, and Paste in Excel 2010

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

Using Paste Options with Copied Data in Excel 2010

Excel 2010 displays a Paste Options button at the end of a pasted range right after you click the Paste button on the Home tab of the Ribbon or press Ctrl+V to paste cell entries that you copy [more…]

How to Use Paste Special in Excel 2010

Microsoft Excel 2010 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 the cell [more…]

How to Use the Clipboard Task Pane in Excel 2010

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

How to Drag and Drop Data in Excel 2010

Drag-and-drop is a mouse technique that you can use in Excel 2010 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 cell [more…]

Using Undo and Redo in Excel 2010

The Undo feature in Excel 2010 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 toolbar [more…]

Automatically Fix Typos and Add Text with AutoCorrect in Excel 2010

Excel 2010'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…]

Moving Excel 2010 Data from Rows to Columns and Back Again

In Excel 2010, you can transpose worksheet data if you want to change the data structure so that the row headings appear as column headings, or vice versa. Excel 2010 provides the Transpose command in [more…]

How to Check Your Spelling in Excel 2010

Microsoft Excel 2010 includes a built-in spell checker that can catch and correct spelling errors and typos in your worksheets. Excel 2010's spell checker normally looks for misspellings only in the current [more…]

How to Edit Records in an Excel 2010 Table

As you work with Excel 2010 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 Excel 2010's Cell Comment Feature

You can add a cell comment — an electronic version of a sticky note — to any cell in an Excel 2010 worksheet. Comments allow those reviewing a worksheet to provide instruction, for example, noting how [more…]

Speeding Data Entry with Excel 2010's AutoFill Feature

Use Excel 2010's AutoFill feature to quickly create a series of entries based on the data you enter in one or two cells. AutoFill works with days of the week, months of the year, and yearly quarters. If [more…]

Learning anything is easy with For Dummies eLearning!

Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.