To set worksheet column according to text length
 Select the column >Click on Home tab > Click on format button > Click on Autofit column width
To delete the column from Works sheets
 Select the column >  Click the Home tab >  Click on delete button > Click on delete sheet columns
Fill Color in Cells
Select the cell range > Click on Home tab >Click on fill color > Click on color
To Change the font Color
Select the cell range > Click on Home tab > Click on font color and choose the color
To Set Border on Selected cell range
 Select the cell range >Click on Home tab >  Click on format button > Click on ‘format cells’ option > Choose type of Border > Choose border color > Click on Outside and inside > Click ok
To write on text warp in selected cell
 Select the cells > Click on warp text button(in Home menu) > Write anything in cell
To set the conditional formatting on selected cell range
 Select the cell range > Click on Home tab >Click on conditional formatting >Click on highlight cell rules > click on more rules > set the rule of conditional formatting > click on format button and set the format > click ok
Set the column width
 Select the column > Click on format button on Home tab > Click on column width > Set the column width and click ok
Set the Row height
 Select the rows > Click on format button on Home tab > Click on row height > Set the height > Click ok
To Copy the Sheets
Click on format button in Home tab > Click on move or copy sheet > Select new book >Check on create a copy
To rename a sheet
 In Home tab click on format button > Click on rename sheet > Type sheet name and press enter key
To change the color of sheet tab
 In Home tab click on format button > Click on tab color >  Select the color you want To protect worksheet >  In Home tab click on format button > Click on protect sheet > Type password and click on ok >  Retype your password and click on ok again
To unprotect a worksheet
 In Home tab click on format button  >  Click on unprotect sheet  > Type password and click on ok
To create a password protected file
 Click on Office Button  >  Click on Save As  > Click on Tools button >  Click on General Options >  Type your password in password to open box >  Re-enter your password and click on ok > Click on save and then click on yes
To insert a chart
 Select the data on which you are going to create a chart. >  Click on ‘Insert’ menu. >  Click on the chart you want to insert.
Santosh kumar singh