SPREED SHEET 2

FONT SECTION:

The Font section of Excel 2007 works a lot like it does in Word 2007. You can change the font style, size, bold, italic, underline, background color, or font color. The difference in Excel is how you select the text to make the changes. In Excel you can change one cell at a time, change just part of the text in a cell or change multiple cells.


To select a single sell click the cell, to select part of the text in a cell double click the cell and then click and drag the cursor over the section you would like to change, and to change multiple cells click and hold the mouse button down and drag it across the cells you want to change. You can also hold down the ctrl button and select cells that are not close to each other.
Now that we know how to select open a spreadsheet you would like to play with or type a few cells so we can see what the font section does. I am going to start a monthly budget sheet.
Select the cell with your heading and then click the down arrow for the font style and choose a new style for your heading. I chose Ariel Black.
Now we want the heading to be a little larger than the rest of the cells so click the drop down arrow for the size. Select a new size for your heading.
Moving right along, the two next buttons (the large A and then small A) will increase or decrease the size of your font if you want to change the font size that way.
The bottom buttons are the B which will bold your text, the I which will italicize the font and the U which will underline the font.
The next button is used for putting borders around cells.
 

Look at the different options and play with them a little to see what they do. You can also select multiple cells to place boarders around. Try doing this also. If you decide you don’t want a border you can always delete them by click the border button down arrow and selecting No Border.
The next button on is the bucket with the colored line under it. This button will fill in the background color of the cell. See if you can change the background color of your title cell.
The next button is the A with the colored line under it. This button will change the font color. If you would like to change all of the font in the cell just click the cell then select your color. If you would only like to change part of the font in the cell double click the cell then highlight the font you would like to change then select a color.


 ALIGNMENT SECTION:

These 3 buttons will align you text in the cell either at the top of the cell, the middle of the cell, or the bottom.
The Orientation button will change the text in the cell so you can align text at an angle, vertical, up, down, or open the Format Cell Alignment window to do more in depth modifications.





Play with these buttons so you can see what each one does. To undo a change click on the selection again and it will put your text back to the way it was.
These 3 buttons will align you text horizontally in the cell. You can align the text right, center or left.
The next 2 buttons are used for indentation. The button on the left will decrease the indent from the left margin on your text. The button on the right will increase your indent.
The last 2 buttons in the Alignment section are used to make your text fit in the cells. Notice in the budget that I am creating some of my words are cut off, I have a few options to choose from to fix this.

• I can use the Wrap Text button on the top next to the orientation button to wrap my text to make it fit.
• I can place my cursor in between the A and B column on the line so it makes a cross with an arrow on each side and double click. This will make the column as big as my largest cell
• Or I can place my cursor like I did above and click and drag to make the cell a custom size. These options work with the rows also. Just place your cursor between two of the numbered rows and either double click or click and drag.

Now I would like my title to be centered across the top of my page. To do this you can merge cells together with the last button in the Alignment section. The Merge and Center Button.
Click and drag your mouse across the cells you would like to merge and center, then click the Merge and Center button.

Notice that I did the same thing with the Monthly Income cells. Then I highlighted the cells and place a boarder around them and then selected the 2 monthly income cells and centered them vertically.