-->

Microsoft-Excel 2007 Study Material Day- Eight

Cells Groups :



Insert Cells,Rows and Columns :
To insert cells,rows and columns in excel.place the cursor in the row below where you want the new row or in the column to the left of where you want the new column.
Steps :
  • Click the insert button
  • Click the appropriate choice : Cell,Row or Column.
Delete Cells,Rows and Columns :
To delete cells,rows and columns,place the cursor in the cell,row or column that you want to delete.
Steps :
  • Click the delete button
  • Click the appropriate choice : Cell,Row or Column
Format : Change column width and row height ,to change the width of a column or the height of a row.

Cell Size: 
Row Height : Change the row height.
Auto Fit Row Height : It is used to automatically set the row height.
Column Width :  Change the column width.
Auto Fit Column Width : It is used to automatically set the Column Width.
Default Width : To Set Default  Standard Column Width : 8.43

Visibility: 
Hide or Un-hide Rows or Columns or Sheet :
Steps :
  • Select the row or column or you sheet wish to hide or un-hide.
  • Click the format button
  • Click Hide or Un-Hide

Organize Sheet :
Rename Sheet : Change the selected sheet name.
Move or Copy Sheet : This option used to create a duplicate sheet.
Tab Color : Change the tab Color.

Protection : 
Protect Sheet :
It is used to protect sheet with a password,It is not allowing us to enter,delete or modify the text.
Steps :
  • Click on Format Button
  • Select Protect Sheet
  • Type Password
  • Click on Ok button
  • Re-Enter the password
  • Click on OK button
Un-Protect Sheet : It Protect to un-protect sheet.
Steps :
  • Click on Format Button
  • Click on Un-Protect sheet
  • Enter the password
  • Click on OK Button

No comments: