Microsoft Excel Tutorial - 02

Ovoya Academy

Microsoft Excel Tutorial - 02

To display a worksheet:

                Click the sheet tab of the worksheet you want to display.

To create a new worksheet:      

1.       Right-click the sheet tab of the worksheet that follows the location where you want to insert a worksheet, and then click Insert.

2.       In the Insert dialog box, double-click Worksheet.

To rename a worksheet:

1.       Double-click the sheet tab of the worksheet you want to rename.

2.       Type the new name of the worksheet, and then press.

To copy a worksheet to another workbook:

1.       Open the workbook that will receive the new worksheets.

2.  Switch to the workbook that contains the worksheets you want to copy, hold down the key, and click the sheet tabs of the worksheets you want to copy.           

3. Right-click the selection, and then click Move or Copy.

4. Select the Create a Copy check box.

5. In the To Book list, click the workbook to which you want the worksheet(s) copied.   

6. Click OK.

To change the order of  worksheets in a workbook:

                Drag the sheet tab of the worksheet you want to move.

 To hide a worksheet:

1.       Hold down the key and click the sheet tabs of the worksheets you want to hide.

2.       Right-click any selected worksheet tab, and then click Hide.

To unhide a worksheet:

1.       Right-click any worksheet tab, and then click Unhide.

2.       Click the worksheet you want to unhide, and then click OK.

    

Written by:

Mohammad Younus