Diane Koers

Step by Step / Updated 04-14-2017

Use the Custom AutoFilter dialog box in Excel 2010 to locate records that either match all criteria or meet one or the other criteria. You can use this method when you want to filter data based on a range of values (for example, you can filter for values that are greater than or equal to 1,000 in a specified column). Excel 2010 tables automatically display filter arrows beside each of the column headings. To display the filter arrows so that you can filter data, format a range as a table using the Table button on the Insert tab. Or, you can click the Filter button in the Sort & Filter group on the Data tab.

Step by Step / Updated 04-11-2017

With Excel 2010's advanced filtering methods, you can specify complex filtering criteria and designate a specific area of your worksheet to manage your criteria selections when filtering table data; for example, you can filter by date. Use the following directions to filter data that has been formatted as a table in Excel 2010.

Step by Step / Updated 03-10-2017

Use the Convert Text to Columns Wizard in Excel 2010 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 data often results when you open or import files created in another application.

Step by Step / Updated 01-25-2017

In Excel 2010, you can use the Document Information Panel to add or change workbook properties such as the Author, Title, Keywords, Status, and Comments that relate to a specific workbook. Adding metadata such as this can help you to better identify and manage your workbook files.

Step by Step / Updated 03-27-2016

The Ribbon interface in Microsoft Office Excel 2010 may seem tricky to navigate until you get used to how commands are organized. The File tab on the left side of the Ribbon provides access to commands related to file management, such as opening, saving, printing, sharing, and closing files. Let’s take a tour of the Ribbon:

Step by Step / Updated 03-27-2016

Excel 2010, like the Office versions before it, has a lare number of built-in keyboard shortcuts that let you choose any Excel command without removing your fingers from the keyboard. The most common Excel commands have always had Ctrl-key shortcuts (such as Ctrl+S to Save), and those shortcuts still work. But now you can use keyboard shortcuts to access uncommon Excel commands.

Step by Step / Updated 03-27-2016

In Excel 2010, you can hide any worksheet in a workbook to remove it from view so that others cannot see the data it contains. You can unhide the worksheet at any time. All formula references to a hidden worksheet are still valid even when a worksheet is hidden.

Step by Step / Updated 03-27-2016

You can hide and unhide rows or columns in Excel 2010 when you don’t want part of the worksheet to be visible or when you don’t want certain data (such as salary information) to appear in printed reports — hidden rows and columns do not print. You cannot hide selected cells; only entire columns or rows.

Step by Step / Updated 03-27-2016

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 (such as ! " # $ % & * < = >) and finally, alphabetic letters. Sorting data in ascending order sorts text from A to Z; numeric information from low to high; and dates with the earliest date first. Sorting data in descending order sorts text from Z to A; numeric information high to low; and dates with the most recent date first.

Step by Step / Updated 03-27-2016

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 to sort on next if two cells in the main sort column contain the same value or data. Although the most common sort is by rows, you can also sort by columns. In the Sort dialog box, click the Options button, choose Sort Left to Right, and click OK.