Edit Menu
TO SELECT ENTIRE ROW.
Move the mouse pointer over the row number which you want to select.
Press the mouse button once.
TO SELECT ENTIRE COLUMN.
Move the mouse pointer over the column label which you want to select.
Press the mouse button once.
TO SELECT THE ENTIRE WORKSHEET.
Move the mouse pointer over the top left corner of worksheet.
Press the mouse button once.
Using Cut/ Copy/Paste.
Þ Select the required cells which you want to copy or move.
Þ Click on Edit menu.
Þ Click on copy or Cut command as required
Þ Then place the active cell at the required cell
Þ Click on Edit menu. .
Þ Click on Paste Command
[You can also use the shortcuts to copy, cut and paste as in Ms Word such as Ctrl+c, Ctrl+x, Ctrl+v]
To fill series of Numbers and Data.
To Fill Numbers.
Þ Put the active cell at the required cell.
Þ Type First and Second number in First and Second cell.
Þ Then select the both cell.
Þ Move the mouse pointer over the bottom right corner of second cell.
Þ Drag the fill handle as required.
To fill date
Þ Put the active cell at the required cell.
Þ Type Sunday or January in First cell.
Þ Then move the mouse pointer over the bottom right corner of first cell.
Þ Drag the fill handle.
Using Clear Command
Þ Select the required cells which you want to clear.
Þ Click on Edit menu.
Þ Click on Clear command.
Þ Then click on All option to clear everything with formatting, contents etc,
Þ Click on formats option to clear only the formats.
Þ Click on Contents option to clear only the contents.
Þ Click on Comments option to clear the comments only.
To delete cells, rows, columns
Þ Select the required cells or rows or columns which you want to delete.
Þ Click on Edit menu.
Þ Click on Delete command.
Þ If you have selected cells then a dialog box appears.
Þ Choose any option. [Shift cells left, shift cells up etc.]
Þ Click on Ok.
To delete worksheet.
Þ Select the required sheet name which you want to delete.
Þ Click on Edit Menu,
Þ Click on Delete sheet command.
Þ Then a message box will appear.
Þ click on ok
TO MOVE OR COPY SHEETS.
Þ Select the required sheet name.
Þ Click on Edit menu.
Þ Click on Move or Copy sheet command.
Þ Then a dialog box will appear
Þ Choose any option from before sheet list.
[If you want to create a copy of the selected sheet click create a copy option]
Þ Click on OK.
USING FIND AND REPLACE COMMAND.
Find:
Þ Click on Edit menu.
Þ Click on Find Command
Þ Then a dialog box will appear.
Þ Type a required text or data in find what box.
Þ Click on Find next button.
Replace:
Þ Click on Edit menu
Þ Click on Replace command
Þ Then a dialog box will appear.
Þ Type the required text or data in find what box which you want to replace.
Þ Type the replacing text or data in Replace with box.
Þ Then click on Find next.
Þ Click on Replace or Replace all bottom as required.
USING GO TO COMMAND
Þ Click Edit menu.
Þ Click on Go to command.
Þ Then a dialog box will appear.
Þ Type the cell name in reference box.
Þ Click on OK.