Lesson 3.Formatting Spreadsheet Part 4

This is the last part of this lesson where we summarise

• The trick to get a well formatted spreadsheet is try and look
• Give it a shot and find for yourself
• Some of theings we studied was how to prepare a dull worksheet to a presentable report
• Tools like grouping, hiding cells and column, merging cells, filling colurs are some of them
• Using various colour combination of patterns a lot of life can be put in reports
• Hiding rows and columns help the user to display only the part which he wants to present
• Grouping is user friendly eg: A person wants to present regionwise sales he may do so but he can provide a group inside which there would be citywise sales. So if the user wants to know that he may do so by ungrouping them
• If there are calculation in the spreadsheet which have to be hidden or protected then cell protection is useful as it preserves the report from being changed