Excel 2010 Data

Sorted by:  

Adding the Excel Camera Tool to the Quick Access Toolbar

The Excel Camera tool enables you to take a live picture of a range of cells that updates dynamically while the data in that range updates. Although Microsoft doesn't include the Excel Camera tool in the [more…]

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

How to Delete Cells and Data in Excel 2010

In Excel 2010, when you need to delete data, remove formatting in a cell selection, or remove entire cells, rows, or columns, you have many options. Excel can perform two kinds of cell deletions in a worksheet [more…]

Inserting Cells, Rows, or Columns in Excel 2010

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

How to Name a Cell or Range in Excel 2010

Assign a descriptive name to a cell or range in Excel 2010 to help make formulas in your worksheets much easier to understand and maintain. Range names make it easier for you to remember the purpose of [more…]

Managing Range Names in Excel 2010

If you’ve created a number of range names in an Excel 2010 worksheet, you can use the Name Manager to work with these names. The Name Manager provides a list of all names assigned in the current workbook [more…]

How to Protect Cell Data in Excel 2010

After you finalize an Excel 2010 worksheet by reviewing formulas and proofing text, you should consider protecting cells in the worksheet to guard against any unplanned changes. Each cell in the worksheet [more…]

How to Sort Excel 2010 Data on a Single Column

You may find data in Excel 2010 worksheets easier to view if it's sorted on a particular column, in ascending or descending order. Excel sorts in the following pattern: numbers, spaces, special characters [more…]

How to Sort Excel 2010 Data on Multiple Columns

If your Excel 2010 worksheet has become quite large, using the Sort dialog box to sort on multiple columns can make it easier to find the data you need. The Sort dialog box lets you tell Excel what column [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…]

Learning anything is easy with For Dummies eLearning!

Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com