| A | B |
|---|
| Select a single cell | Click cell |
| Must select cells or range | before issuing command or performing procedure |
| Extend the cell selection | Click cell, hold mouse button down and drag to end of desired range, then release mouse. |
| Select an entire row | Click row header when you see the row header symbol |
| Select an entire column | Click column header when you see the column header symbol |
| Select the entire worksheet | Click the Select All button |
| Make cell selections | Click beginning cell in range, point to ending cell in range and hold (Shift) key down while clicking ending cell in range. |
| Extend the row selection | Click row number, hold left mouse button down and drag. |
| Extend the column selection | Click column letter, hold down left mouse button and drag. |
| Selecting non-adjacent columns, rows or cells | Click cell, column or row. Then move pointer to next cell, column or row, hold (Ctrl) key down, then click and drag. |
| Can undo up to maximum of | 16 commands most recently used |
| Undo history lost | if you close or save workbook |
| Repeat feature only repeats | last action performed |
| Cut | Remove contents of cell or range of cells and place in new area in worksheet. |
| Copy | Copy contents of cell or range of cells to new area in worksheet. |
| Paste | Place contents of cut or copied cells into new cell location. |
| Paste Special | Modify effects of paste option. |
| When you use Cut or Copy, | a marquee appears around the selected cell range |
| To remove a cut or copy marquee: | Press (Esc) |
| To paste item in several cells, | ensure marquee still active on original item, then select Paste in various cells |
| To change column width: | On Home tab, in Cells group, click Format, Column Width |
| To adjust height for row: | On Home tab, in Cells group, click Format, click Row Height |
| To use AutoFit for columns: | On Home tab, in Cells group, click Format, click AutoFit Column Width |
| To insert column or row: | On Home tab, in Cells group, click arrow for Insert |
| To delete selected column or row: | On Home tab, in Cells group, click arrow for Delete |
| To rename worksheet tab: | On Home tab, in Cells group, click Format, click Rename Sheet |
| To insert new worksheet: | On Home tab, in Cells group, click arrow for Insert, click Insert Sheet |
