Customize cells format means one or more cells. This feature helps us work better in our spreadsheet. The formatting can vary depending on the calculation that we do.
Es . If I have to calculate in euro, format the cell with the euro currency. If I have to calculate in fractions I have to select the locality. To format cells, you must first select one or more desired cells by dragging the left mouse button.
buttons formatting such as Word, Excel also are present in the tab bar multifunctional Home . But we're going to click the right button on the selected area and then click on Format Cells .
There is this window (picture left). In the Format Cells six tabs appear. Starting
the first, we can choose what will appear when you type a number in the boxes checked. The
Card Number consists of "two columns". On one hand, we decide the Category and on the other customize . From Category Number you can decide how many decimal places we want to have as Excel shows us the negative number. In the other categories we can decide the currency symbol, the positions in the percentage and more easy to discover and understand. So I leave you the honor of exploring the Number tab. More From Alignment , we can decide the 'orientation Text placed in the cell. This will deform the cell size. The Character Card is easy to understand. Used to customize writing. The same things are possible activate the card Home bar multifunctional (As I said at the beginning!). In a few words in this tab, you activate the bold, style, size and all these things we have already seen in Word. The Border tab , we need to tread the edge of one or more selected cells and form a sort of table to define the area in which we work. In this tab customize the line style and color of it. Right we see a diagram that shows the border around the cell lines. To do this, you must click on the buttons around. OGN 'one of these buttons corresponds to the insertion of an edge to one side. In the Fill tab there is nothing to understand, but much to do! Clicking on a color contained in the color palette, fill all the selected cells from the chosen color. Finally, in the Security Tab we can put the " mustache" (the V-sign) in blocks and hidden. These commands are activated (the description is written down to the choice of controls on the Security tab) only if the sheet is password protected. To protect
a paper should go to the tab bar Revision multifunctional and click Protect Sheet (The first image). A window appears where you enter a password. The protection is not to modify the contents of the protected sheet, in fact the first option that is required is "Protect worksheet and contents of locked cells". After the password and decide what any user who does not know what the password can select or insert. Share on Facebook 
0 comments:
Post a Comment