To enter a data series using AutoFill
Type the first label or value for your list.
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
To enter data by using AutoComplete
To enter data by picking from a list
Right-click a cell in a column with existing values and click Pick from Drop-down List from the shortcut menu.
Click the item in the list you want to enter.
To copy and paste cells
Select the cell you want to copy.
On the Home tab, in the Clipboard group, click Copy.
Click the cells into which you want to paste the values.
On the Home tab, in the Clipboard group, click Paste.
To copy and paste a row or column
Select the row or column you want to copy.
On the Home tab, in the Clipboard group, click Copy.
Click the header of the row or column into which you want to paste the values.
On the Home tab, in the Clipboard group, click Paste.
To find data within a worksheet
Click the Home tab.
In the Editing group, click Find and Select.
Click Find.
Type the text you want to find.
Click Find Next.
Click Close.
To replace a value with another value within a worksheet
Click the Home tab.
In the Editing group, click Find and Select.
Click Replace.
Type the text you want to replace.
Type the text you want to take the place of the existing text.
Click Find Next. Follow any of these steps:
Click Replace to replace the text.
Click Find Next to skip this instance of the text and move to the next time it occurs.
Click Replace All to replace every instance of the text.
Click Close.
To edit a cell’s contents by hand
Click the cell you want to edit.
Select the text you want to edit in the Formula Bar.
Type the new text and press Enter.
To check spelling
On the Review tab, in the Proofing group, click Spelling. If you are asked whether you want to save your work, do so.
Follow any of these steps:
Click Ignore Once to ignore the current misspelling.
Click Ignore All to ignore all instances of the misspelled word.
Click Add to Dictionary to add the current word to the dictionary.
Click the correct spelling and then click Change to replace the current misspelling with the correct word.
Click the correct spelling and then click Change All to replace all instances of the current misspelling with the correct word.
Click Cancel to stop checking spelling.
Click OK to clear the dialog box that appears after the spelling check is complete.
To look up a word in the Thesaurus
To translate a word to another language
To create a data table
Type your table headers in a single row.
Type your first data row directly below the header row.
Click any cell in the range from which you want to create a table.
On the Home tab, in the Styles group, click Format as Table.
Click the desired table style.
Verify that Excel identified the data range correctly.
If your table has headers, select the My table has headers check box.
Click OK.
To add rows to a data table
Follow either of these steps:
To resize a table
To add a Total row to a column
To change the Total row summary function
Click any cell in the table’s Total row.
Click the down arrow that appears.
Click the desired summary function.
To rename a table
18.117.159.229