Worksheet Formatting

Worksheet Formatting

Introduction  - Inside a cell you can enter many types of data like Text, Number, Formula etc.

1. Text  - Text data refers to the letters of Hindi and English.
2. Number  - Numbers include numbers from 0-9 and some special mathematical characters, such as $, %, +, - etc.
3. formula  - For automatic execution of calculation, we write the formula in the cell. We start writing the formula in any cell with an equal sign (=). We can choose the appropriate formula by going to the formulas menu or we can also write it ourselves. For example, to automatically enter today's date in the cell, write this - =Today() .

Entering the Formula

To type a formula in a cell in Excel, first select that cell. Then type the equal sign (=) and type the formula. After that press enter. After selecting a cell, the formula typed in it is displayed in the formula bar.

Editing a Cell's Content

Once you type any type of data in a cell, after that you can also edit it. To edit the content of the cell, follow these steps-

1. Select the cell that you want to edit.
2. Press the 'F2' key or click 2 times inside the cell.
3. Make changes as required and press the enter button.

Cell Key Range

In MS excel, the selection of more than one cell is called range and the group of selected cells is called block. Any work in which more than one cell is used, it is done by making blocks.

Selecting a Range

To select a range, follow these steps-

1. Position the mouse pointer on the first cell of the range.
2. Click and drag the mouse to the last cell of that range.
3. To select the entire column or row, move the mouse pointer over the column heading or row heading and click.

aligning the contents of a cell

Cells in Microsoft excel are "text" left aligned and "number" right aligned by default. But the contents of a cell can be aligned using the following alignment-

1. Align left  - This alignment is used to align numbers and text to the left.
2. Align right  - This alignment is used to align the text or number right.
3. Align center  - This alignment is used to center align text and numbers.

Movement of Cell Pointer in Worksheet

The cell pointer in the worksheet can be easily moved from the keyboard. 8 keys of the keyboard - Home, End, Page up, Page down, Arrow keys work in the movement of the pointer. The speed of movement of the pointer is accelerated with the use of the above keys along with the Ctrl and Shift keys.

1. Arrow keys  - Moves the cell pointer one cell up, down, left and right.
2. Home  - Moves to the first cell of the row.
3. CTRL+Home  - Moves to the beginning of the worksheet.
4. CTRL+End  - Moves to the end of the worksheet.
5. Page up  - Moves the cell pointer up one screen.
6. Page Down  - Moves the cell pointer down one screen.
7. Alt+Page up  - Moves one screen to the left.
8. Alt+Page down  - Moves one screen to the right.
9. Ctrl+Page up  - Moves to the next sheet in the workbook.
10. Ctrl+Page down  - Moves to the previous sheet in the worksheet.

Formatting a cell

Various ways to format cells are available in MS excel. Like- General, Number, Currency, Date, Text etc.

The format of the cell is as follows-

1. Number format  - It is used for formatting of numeric data. Like how many decimal digits should be in the number and the number system will be Indian or International. 
2. Currency format  - It is used to convert the number entered in a cell into currency.
3. Date format  - It is used to convert a number entered in a cell to a date.
4. Time format  - It is used to convert the number entered in a cell into time.