Formatting A Text and Numbers
Category : 6th Class
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:
How to Do Text Alignment
It allows you to align the Text of the document.
Implementation of Text is done in the following way:
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)
Implementation of Conditional formatting is done in the following manner:
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:
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:
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:
You need to login to perform this action.
You will be redirected in
3 sec