Today the teacher taught us how to colour the cells in our assignment. On Microsoft Excel 2007 you could just highlight the cells you want to colour than you just go to the home button and the colour button choose your colour and click apply, so that the backgrounds of the cell will change. You can also change the colour of the words, its beside the background colour button with the letter A and the colour under it change the colour if you want but if your background is black then change it so you can see. Another way to change the background in Microsoft Excel 2007 is go to Home than go to cell style than choose a style to make the background of you cells.
Cell Style (Microsoft Excel 2007):
Home, Styles, Cell styles
Colour Backgrounds (Microsoft Excel 2007):
Home, Font, Fill colour
Colour font (Microsoft Excel 2007):
Home, Font Font colour
These are the steps to colour cells with colour styles, you can also add a pictures as backgrounds but I don't suggest you do it because you have to cite it but if you want to know here it is:
Picture Background: (Microsoft Excel 2007):
Page Layout, Page Setup, Background, Choose the picture.
Beware this is a repeat background, and it may look horrible, but it is just for me to know.
To remove or put you value into the decimal point you want it you click on the cell and you can do one of the following:
Removing Decimal places (Microsoft Excel 2007):
1. Home, Number, Decrease Decimal (Be warned it goes 1 by 1 so it may take a long time to remove continuous decimals, you can also add decimal place by clicking on Increase Decimal instead.
2. Home, Cell, Format, Format Cell, Number, Select decimal places
3. Right mouse button, Format Cell, Number, Select decimal places
4. Crtl 1, Number Select decimal places
Any of these ways are fine but I like number 4 because it is the fastest way.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment