*****Keep the dummy report open while reading this*****In case you don't have the dummy report mail me at
vmani32@yahoo.co.in with Subject as Dummy Report
- After grouping of rows and columns we now move on to filling coulours in cells. Ed Cell D18
- You can fill coulours by two ways - Right click on the cell and format Cells or use the fill toolbar on the top
- Lets see what are the options we get when we right click on a cell
- There are six tabs that one gets when right click on cell
- Number, Alignment, Font, Border, Patterns and Protection
- Number: This category is used to specify the format of the contents of the cell which can be classified as general or number or currency etc. Based on the content you can choose
- Alignment: This is to align the content of the cell. You can also change the angle of the content
- Font: Here you specify what will the font of the cell content be along with the size
- Border: Here you can decide the pattern of the border with the colours of the border for the cell
- Pattern: Here you cn decide the colour to fill the cell with. You can also specify certain design to fill the colour
- Protection: Has 2 options locked and hidden. Locked is when no one can make changes to the cell if worksheet is protected( Will discuss this in later lessons). Hidden means the cell formulae are not displayed
No comments:
Post a Comment