How to add a border line in Excel sheet

Add a Border line to Cells

          A border can be given to your cells in the Excel Sheet. We can add to only one side or two side or even all the four sides.

1. Select the cell or range of cells to which border can be added.

2. Select Border button. A drop down box appears.

3. Select a border option i.e., Bottom border or All Borders.

4. The selected border appears to the selected range of cells.

Protecting your Excel Sheet

         Suppose you have entered the salary details of all employees. After your exit from the office, somebody may change the salary details. In this connection, let us know how to avoid changing the details in your Excel Sheet.

1. Open the work sheet which you want to protect from others.

2. Click on Format.

3. Click on Protect sheet. Consequently, the Protect Sheet dialog box appears.

4. Type your Password.

5. Click on OK.

6. A box appears asking you to type the Password Again.

7. Click OK.

          Now close the work sheet and open again. Try to type a wrong number in the password box. The excel will not permit you to open the excel sheet. When you type the correct password, the excel sheet opens. You can now edit the data in your worksheet.

Inserting an additional Row or Column

          While performing some calculation in excel, sometimes need arises to add an extra row in the middle of the sheet.

1. Place the mouse on the row where you want to insert a new row and then right click the mouse. A sub-menu appears.

2. Select Insert. The Insert dialogue box appears.

3. Select the Entire Row in the Insert dialogue box.

4. Click on OK.

5. Consequently, a new row appears.

Note: Similar procedure is to be followed for inserting new columns.

Removing the Row or Column

1. Select the row or columns which you want to remove. Then Right click the mouse. A sub menu appears.

2. Click on Delete in the sub menu. The Delete dialogue box appears.

3. Select the Entire row in the delete dialogue box.

4. Click on OK.

5. The blank row disappears.

Hiding some rows or columns

         Excel facilitates the user to hide some of the rows or columns in the sheets so that secrecy can be maintained.

1. Highlight the rows or columns which you want to hide.

2. Click on Format > Hide and Unhide.

3. Select Hide Row.

4. See the result. Excel hides the two rows ( Pradeep and Sarma ) and shows the remaining rows.

Displaying the hidden Columns and Rows

1. Click on Format > Hide and Unhide > Unhide Rows.

2. Then the hidden rows and columns appear on the sheet.

Placing the currency symbols before numbers

          While typing the data in Excel, we should not type rupees or dollar symbols in front of the numbers. If we type Rs. symbol, Excel thinks it is text and so it cannot perform mathematical calculations. Excel automatically inserts Rupees symbol in front of numbers.

1. Select the column or Row for which we need (Rs.) Rupees symbol.

2. Click on Home > Format > Format Cells. The Format cells dialog box appears.

3. Click on Currency and select Rupees under the symbol list.

4. Click on OK.

5. See the Result.

Note: if there is no Rs. symbol in the list, then go to Desktop and click on control panel > Date, Time, Language and Regional Options > Change the format of numbers, dates and times. Then Regional and Language options dialog box appears. click on Customize and click on Currency pane and type Rs. against the currency symbol and click on apply. Also close regional and language options dialog box by clicking on apply. Then Rs. symbol appears on Format cells dialog box. You can select the Rs. and can be applied to your cells.

PRACTICAL EXERCISE

          Open the 'student marks' work sheet.

1. Convert the data into Bar and Pie charts.
2. Change the data into Auto Format by selecting a good design.
3. Protect the worksheet by giving a password to it.
4. Open the worksheet of 'student marks' in M.S Excel unprotect the worksheet by giving your password.
5. Obtain a list of the top two students marks.
6. Remove the student name 'Kiran' from the original list. Place the name of 'Ajay' in its place and type the following marks---( 79, 87, 67, 91, 100, 93)
7. Calculate the revised total marks of all the students.