Working with Data and Data Tables

To enter a data series using AutoFill

  1. Type the first label or value for your list.

  2. Drag the fill handle to the cell containing the last label or value in the series.

To change how dragging the fill handle extends a series

  1. Type the first label or value for your list.

  2. Hold down the key, and drag the fill handle to the cell containing the last label or value in the series.

To enter data by using AutoComplete

  1. Type the beginning of an entry.

  2. Press to accept the AutoComplete value.

To enter data by picking from a list

  1. Right-click a cell in a column with existing values and click Pick from Drop-down List from the shortcut menu.

  2. Click the item in the list you want to enter.

To copy and paste cells

  1. Select the cell you want to copy.

  2. On the Home tab, in the Clipboard group, click Copy.

  3. Click the cells into which you want to paste the values.

  4. On the Home tab, in the Clipboard group, click Paste.

To copy and paste a row or column

  1. Select the row or column you want to copy.

  2. On the Home tab, in the Clipboard group, click Copy.

  3. Click the header of the row or column into which you want to paste the values.

  4. On the Home tab, in the Clipboard group, click Paste.

To find data within a worksheet

  1. Click the Home tab.

  2. In the Editing group, click Find and Select.

  3. Click Find.

  4. Type the text you want to find.

  5. Click Find Next.

  6. Click Close.

To replace a value with another value within a worksheet

  1. Click the Home tab.

  2. In the Editing group, click Find and Select.

  3. Click Replace.

  4. Type the text you want to replace.

  5. Type the text you want to take the place of the existing text.

  6. Click Find Next. Follow any of these steps:

    1. Click Replace to replace the text.

    2. Click Find Next to skip this instance of the text and move to the next time it occurs.

    3. Click Replace All to replace every instance of the text.

  7. Click Close.

To edit a cell’s contents by hand

  1. Click the cell you want to edit.

  2. Select the text you want to edit in the Formula Bar.

  3. Type the new text and press Enter.

To check spelling

  1. On the Review tab, in the Proofing group, click Spelling. If you are asked whether you want to save your work, do so.

  2. Follow any of these steps:

    1. Click Ignore Once to ignore the current misspelling.

    2. Click Ignore All to ignore all instances of the misspelled word.

    3. Click Add to Dictionary to add the current word to the dictionary.

    4. Click the correct spelling and then click Change to replace the current misspelling with the correct word.

    5. Click the correct spelling and then click Change All to replace all instances of the current misspelling with the correct word.

    6. Click Cancel to stop checking spelling.

  3. Click OK to clear the dialog box that appears after the spelling check is complete.

To look up a word in the Thesaurus

  1. Select the word you want to look up.

  2. On the Review tab, in the Proofing group, click Thesaurus.

To translate a word to another language

  1. Select the word you want to look up.

  2. On the Review tab, in the Proofing group, click Translate.

To create a data table

  1. Type your table headers in a single row.

  2. Type your first data row directly below the header row.

  3. Click any cell in the range from which you want to create a table.

  4. On the Home tab, in the Styles group, click Format as Table.

  5. Click the desired table style.

  6. Verify that Excel identified the data range correctly.

  7. If your table has headers, select the My table has headers check box.

  8. Click OK.

To add rows to a data table

Follow either of these steps:

  1. Click the cell at the bottom right corner of the data table and press to create a new table row.

  2. Type data into the cell below the bottom left corner of the data table and press . Excel will make the new row part of the data table.

To resize a table

  1. Click any cell in the table.

  2. Drag the resize handle to expand or contract the table.

To add a Total row to a column

  1. Click any cell in the table.

  2. On the Design tab, in the Table Style Options group, click Total Row.

To change the Total row summary function

  1. Click any cell in the table’s Total row.

  2. Click the down arrow that appears.

  3. Click the desired summary function.

To rename a table

  1. Click any cell in the table.

  2. On the Design tab, in the Properties group, type a new value in the Table Name box.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.117.159.229