Library Home page | Library Catalog
Skip to main content

Microsoft Office 2010: Working With Data

Filtering

Filtering Data Using AutoFilter
Especially helpful for working with large data sets, you can use AutoFilter to view only parts of your data based on certain criteria. The filter hides those records that do not meet user-selected criteria.
1. Select the column headings for the data you want to filter
2. Navigate to the Data tab on the Microsoft Office Ribbon
3. Navigate to the Filter icon within the Sort & Filter group


 
4. After you select the Filter icon, drop-down arrows will appear within each column heading (field names)
5. Click the drop down arrow on a column heading to filter a table based on a particular field


6. To clear the filters, click the Filter icon again


Data in Cells

Working with Data
Entering Data
1.  Enter numbers or text
    a. On the worksheet, click a cell
    b. Type the numbers or the text that you want and then press ENTER or TAB

Selecting Data
1. To click a single cell, click the cell or press the arrow keys to move to the cell.
2. To click a range of cells, click the first cell in the range and then drag to the last cell or hold down SHIFT while you press the arrow keys to extend the selection



3. To click all cells on a worksheet, click the Select All button in the upperleft hand corner of the worksheet (between Column A and Row 1) or select the entire worksheet by
pressing Ctrl + A



Editing Data
1. To place the contents of a cell in editing mode, do one of the following:
   a. Double-click the cell that contains the data that you want to edit
   b. Click the cell that contains the data that you want to edit and then click anywhere in the formula bar at the top of the worksheet
2. To edit the cell contents, do any of the following:
   a. To delete the characters, press BACKSPACE, or select them and then press DELETE
   b. To insert characters, click where you want to insert them and then type the new characters
   c. To enter your changes press ENTER



Copying and Moving Data
1. Move or copy cells and cell contents by selecting the cells you want to move or copy

CTRL + X = Move Cell Data
CTRL + C = Copy Cell Data
CTRL + V = Paste Cell Data



 

Sorting & Filtering

Sorting
1.  To sort rows in ascending (A-Z/0-9) or descending (Z-A/9-0) order, click
a cell in the column you would like to sort by
2.  Navigate to the Data Tab within the Microsoft Office ribbon
3. From the Data Tab, navigate to the Sort and Filter group
4. Click on the Sort icon


5.  The Sort dialog box will pop open
6.  Sorting can be done by Column headings
7.  Then sorting can be done A-Z or Z-A within the Order option


8.  Click Options within the Sort dialog box (above) to choose to sort top-to-bottom or left-to-right (the default is top-to-bottom)