Microsoft Excel Worksheet

Excel Part 3

Microsoft Excel Worksheet

Moving cursor around the worksheet:

Go to Last Row
= Press END/Ctrl and then Down arrow key
Go to First Row
= Press END/Ctrl and then Up arrow key
Go to Last Column
= Press END/Ctrl and then Right arrow key
Go to First Column
= Press Home key
Go to First Column & First Row
= Press CTRL + HOME key

Go to Specific cell:
Cluck Edit
Click Go To
Reference : Type M 900
Click Ok
Or
Press F5
Reference : Type 900
Click Ok

Exit From Microsoft Excel
Click File
Click Exit
If you save this File Then Select - Click Yes
Otherwise - Click No

Open a New Document :
Click File
Click New
Click Ok
Creating Work book

Saving the Workbook:
Click File
Click Save
File Name [............. ]
Click Save

Closing the Workbook
Click File
Click Close

Open the Workbook
Click File
Click Open
File Name [......... ]
Click Open

Document Security :
Click File
Click Save As
Clock Tools
Click General Options
Password to Open: type password
Click Ok
Reenter  password to Open
Click Ok
File name
Click Save

To Open Password File:
Click File
Click Open
File name: type password
Click Ok

Zoom Control
Click View
Click Zoom
Selection
Click Ok

Insert Column
Set cursor to the column
Click Insert
Click Columns

Insert Row
Set cursor to the Row
Click Insert
Click Row

Delete Columns
Set cursor to the column
Click Edit
Click Delete
Click entire Column
Click Ok

Delete Row
Set cursor to the Row
Click Edit
Click Delete
Click Entire
Click Ok

Changing Column Width
Click Format
Click Column
Click Width
Your Choose
Click Ok
Or
Changing Column Width Using the Mouse Adjusting Auto Column Width:
 To increase or decrease the Width of the Column Automatically
> Move the Cursor to the Column you need
> Select the Column from the format menu
> Choice Auto fit Selection

Changing Row Height
Click Format
Click Row
Click Width
Your Choose
Click Ok
Or
Changing Row Width Using the Mouse
Adjusting Auto Column Width :
To increase or decrease the Width of the Row Automatically
> Move the Cursor to the Row you need
> Select the Row from the Format menu
> Choice Auto fit Selection

Hiding Column
Select Column
Click Format
Click Column
Click Ok

Display or Unhidden
Click Format
Click Column
Click Unhidden
Click Ok

Change Previous Password:
Click File
Click Save As
Click Tools
Click General Options
Password to open: Type new password as you need
Click Ok
Reenter password to open: type new password again
Click Ok
Click Save

Delete password from the Document
Click File
Click Save As
Click Tools
Click General Option
Password to Open : Delete password
Click Ok
Click Save

Copy call contents:
Block cells
Click Edit
Click Copy
Set call Cursor
Click Edit
Click paste

Move cell contents:
Block the cells
Click Edit
Click Cut
Set cell Cursor
Click Edit
Click Paste

Delete cell contents :
Block the cells
Click Edit
Click Delete
Choose
Click Ok

Undo Feature:
Click Edit
Click Undo Clear

Redo
Click Edit
Click Redo

Paste Text
Block the cells
Click Edit
Click Copy
Set cursor ( you want go to cell)
Click Edit
Click Paste special
Click paste Link

Active / de - active Toolbars
Click View
Click Toolbar
Click Selection

Show / Hide Formula Bar
Click View
Click Formula bar

Show / Hide Status Bar
Click View
Click Status bar

Rename Sheet:
Click Right button on Sheet, which you to rename.
Click Rename
Type new name what you need
Click out side the sheet
Or
Click Format
Click sheet
Click Rename
Type new name what you need

Inserting a Worksheet :
The Workbook usually has three Worksheet to increase the sheet if necessary
Click Insert
Click worksheet

Delete Worksheet :
Click Right button in sheet that you want to delete
Click Delete
Click Ok
Or
Click Edit
Click Delete sheet
Click Ok

Copying a Worksheet within the same workbook: