Lesson 3.Formatting Spreadsheet Part 2

*****Keep the dummy report open while reading this*****
In case you don't have the dummy report mailme at vmani32@yahoo.co.in with Subject as Dummy Report

1. Go to Cell D14 ( By now you should be familiar with this convention which means Cell Column D and row 14). You will notice this cell has been joined to many other cells. This is called merging of cells which is used essentially to make your report presentable
2. Sometimes merging is used in the title or sometimes when a heading has two or more topics or subtopics in them
3. Merging helps to highlight the name of the report and shows a span of data. A few examples are Cell H17, H29, F26,etc.
4. Next on the top left corner of the sheet you will notice two numbers 1 and 2 and along the rows you will find a line which is binding rows
5. Try clicking on either 1 or 2 and you will find row getting hidden or visible. This is called grouping. This is how it is done
6. Select a group of rows ( Entire Row) and then Data --> Group and Outline --> Group. By doing this you indicate that all the grouped row as one family
7. Generally it is practiced that in a report the final result is shown and details are hidden by the group. So incase anyone wants to view it he can just expand the group by clicking the + sign outside the group.
8. The top 1 and 2 are indicative of the level of grouping as you can have multiple grouping. In excel 2003 you can have 8 levels of grouping. To expand all the groups you can use these level indicators. Else just click on the + sign next to the group to expand or collapse
9. Similarly you can do this for columns