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 then click Pick from Drop-down List.
Click the item in the list you want to enter.
To copy and paste selected cells
On the Home tab, in the Clipboard group, click Copy.
Click the destination cells. Then in the Clipboard group, click Paste.
To copy and paste a selected row or column
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. Then in the Clipboard group, click Paste.
To find data within a worksheet
On the Home tab, in the Editing group, click Find and Select, and then click Find.
Type the text you want to find, and then click Find Next.
To replace a value with another value within a worksheet
On the Home tab, in the Editing group, click Find and Select, and then click Replace.
Type the text you want to replace, and 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.
To edit a cell's contents by hand
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 selected word in the Thesaurus
On the Review tab, in the Proofing group, click Thesaurus.
To translate a selected word to another language
On the Review tab, in the Proofing group, click Translate.
To create a data table
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 table style you want, and verify that Excel identified the data range correctly.
If your table has headers, select the My table has headers check box. Then click OK.
To add rows to a data table
To resize a table
Click any cell in the table, and then drag the resize handle to expand or contract the table.
To add a Total row to a table
Click any cell in the table.
On the Design tab, in the Table Style Options group, click Total Row.
To change the Total row summary function
Click any cell in the table's Total row, click the arrow that appears, and then click the desired summary function.
To rename a table
Click any cell in the table.
On the Design tab, in the Properties group, type a new value in the Table Name box.