No Excel, each cell is independent of the others, displaying several types of data. With so much information, it is important that these cells are formatted. Thus, your data becomes more organized and clear to anyone who uses your spreadsheet.
To format cells, use the formatting toolbar or right-click on the cell you want to format and choose "Format Cells" as shown below:
The "Format Cell" dialog box is divided into 6 parts: Number, Alignment, Font, Border, Fill, and Protection.
The Number option is subdivided into several categories, as explained below:
General - This option defaults to each cell. Texts and numbers will appear the way they are typed. Example: 23,07 and 23.07, both will be accepted;
Número - Here you have the possibility to format the cell as number and choose the desired decimal places;
Currency - Change the currency cell with the desired dollar sign. The default is Real, but you can choose the Dollar (USD), for example.
Accounting - Unlike the previous item, in spite of transforming the cell into the desired currency, in this type of formation zero values are shown as dashes, aligning all currency symbols and decimal places, and negative values display in parentheses, making it easier for company accounting .
Date and time - It is used to identify the date or time of day when the worksheet is being performed. The most commonly used options are dd / mm / yyyy or mm / dd / yyyy.
Percentage - Changes the cell to the percent format;
Fraction - Format the cell (number) as a fraction;
Scientific - Here it is possible to use the scientific form (E of exponential) in the desired cell;
Text - Check this selection when entering only text and specific numbers;
Special - In this option you can format in any type of number you want and even create new formatting.
The Alignment option has 4 types of formatting to be used in the text, they are:
Text alignment - Selects the type of text alignment: left, right, centered or justified;
Text Orientation - Choose how the text will appear: vertically or horizontally or even at some intermediate angle between the two;
Control of text - Break the text automatically, reducing it to fit in the cell or merge the selected cells;
Direction of the text - Here it is possible to change the direction of the text, that is, whether it will start from left to right or from right to left or in context format.
The Font option has 5 possible formatting for the cell:
Source - In this option, you select the desired source;
Underline - Lets you choose the type of underline or no type of underline;
Effects - Changes cell for strikethrough, superscript and subscript;
Font style - Format the contents of the cell from the regular, italic, bold or bold italic options;
Size - Used to change the size of the desired font;
Color - Changes the text color or number present in the cell.
The Border option has 4 options to choose from:
Line - Causes the cell to have a border with a certain type of row from the available options;
Color - Lets you choose border color;
Definitions - Here you predefine the desired border type in the cells between: none, full contour or internal contour;
Edge - Formats cells with other border options.
The Fill option has 3 possible formatting:
Background Color - Fill the cell with the chosen color;
Pattern Color - The background color of the cell is change to the chosen texture or color;
Pattern Style - You can choose the desired pattern from the available options;
The last option, Protection, allows you to hide or block a cell, if desired;
As you can see, there are several possibilities for formatting cells. Just choose the one that applies to your data. Good job!