6th Class Computers Getting Started with Spread Sheet Formatting A Text and Numbers

Formatting A Text and Numbers

Category : 6th Class

*      Formatting A Text and Numbers

 

Various formatting styles on Text and Numbers as per requirement are permitted by Excel. The document become more feasible, pleasing appearance also shows more values by using these formatting styles. You need to click a particular eel and starting typing to enter data in cell of worksheet. By pressing Tab and Arrow Keys of the keyboard you can enter the data.                                

 

*  How to Select Cell Or Cell Range

If you want to perform any operation on data then you need to select cell or range of cells.  

 

*   You need to follow the/allowing steps to select the cell or cells in a worksheet: 

  • Firstly click the cell which you want to select and same in case of range of cells, you need to press and the document through mouse in the starting cell.
  • Then move the mouse to destination or end cell and release it.  

 

*   How to Do Text Alignment

It allows you to align the Text of the document.  

 

*    Implementation of Text is done in the following way:

  • Firstly select the cells on which you need a text to be align.
  • Then select Format  Cells  Alignment tab to open format cells dialog box, as shown in the following figure:
  • Further you need to select the desired option to align text vertically or horizontally in the Text alignment area.
  • Then click OK for accept the settings.    

 

*   Implementation of Conditional Formatting

Editing the style of Text, numbers and the pages based on conditions are performed under formatting option. If the contents in the Cells satisfied those conditions then the formatting will took effect. Therefore, there is no need to make any changes and check the conditions manually. (See Figure)

 

  Format cell.jpg

 

 

*   Implementation of Conditional formatting is done in the following manner: 

  • To display the Conditional Formatting dialog box, select Format  Conditional Formatting, as shown in the following figure: (See Figure)
  • Then select the type of condition from the  dropdown list according to the requirement.
  • After that select the range of the cells which are needed.
  • Then to add more conditions click Add.
  • Finally to accept the changes click OK.  

 

conditional formating.jpg

 

*   How to Format a Text

As per the requirement you can format a Text, such as changing the font of Text from Arial to Times New Roman or by changing its size from 8 to 72.    

 

*  Formatting of Text can be done in a worksheet in the following way: 

  • Firstly select the text, which need to format.
  • Then to display the Font tabbed page, select Format  Cells Font, as shown in the following figure: (See Figure)
  • Finally to apply the settings click OK.  

 

format-cells-font.jpg

 

*  How to Format the Numbers

To change the property of a value in a cell to fraction, time, text and many more is permitted by Formatting numbers.

 

*  Number Formatting is done by performing the following steps: 

  • The cells which you need to format, select it first.
  • To display the Numbers tabbed page, select Format  Cells Number, as shown in he following figure: (See Figure)
  • According to the requirement to format the number select the Number attributes.
  • Then to apply the settings click OK.  

 

3.jpg

 

*  How to do Coloring the Cells

You may fill the colour and a specific pattern in a cell.  

 

*  Colours in the Cell can be filled as: 

  • To display the Pattern Tabbed page, select Format  Cells  Patterns tab, as shown in the following figure:
  • From the Color Pallet select the Color and a specific pattern.
  • To accept the changes click OK button.  

 

  

 

You need to login to perform this action.
You will be redirected in 3 sec spinner

Free
Videos