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 :
Visibility:
Organize Sheet :
Protection :
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
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
Steps :
- Click on Format Button
- Click on Un-Protect sheet
- Enter the password
- Click on OK Button
Follow @Sarvavasi.com