sponser

Thursday, December 10, 2009

Selecting the Required Data using Mouse

Selecting the Required Data using Mouse
1.6.1. To select cells
Ø Click on the cell to select a single cell
Ø Click on the cell and drag the mouse to desire direction for multiple cell selection.
1.6.2. Select a Row or column
To select a row or column click on the row or column header
1.6.3. Copy and Paste
To copy and paste data:
Ø Select the cells that you wish to copy
Ø On the Clipboard group of the Home tab ,click Copy
Ø Select the cells where you would like to copy the data
Ø On the Clipboard group of the Home tab ,click Paste
1.6.4. Cut and Paste
To cut and paste data:
Ø Select the cells that you wish to copy
Ø On the Clipboard group of the Home tab ,click Cut
Ø Select the cells where you would like to copy the data
Ø On the Clipboard group of the Home tab ,click Paste
1.6.5. Undo and Redo
To undo or redo you’re most recent actions:
Ø On the Quick Access Toolbar
Ø Click Undo or Redo
1.6.6. Auto Fill
The Auto Fill feature fills cell data or series of data in a worksheet into a selected range of cells .If you want the same data copied into the a selected range of cells .If you want to have a series of data (for example, days of the week) fill in the first two cells in cells in the series and then use the Auto fill features. To use the Auto Fill Features:
Ø Click the Fill Handle
Ø Drag the Fill Handle to complete the cells
1.6.7. To delete data
Select the desired data, which you want to delete, and then press Delete, then press
[Delete] key or [Backspace] Key.
1.6.8. To recover any recently deleted (Modified data)
If you delete any important data by mistake, click on the [Edit] menu and select [Undo] command to recover it, (or, press [Ctrl] + [z] or [Undo] button on the Standard toolbar).

No comments:

Post a Comment