From the Group dropdown list select Auto Outline. To outline this, click somewhere inside the range containing the data and next click the Data tab. You can outline a worksheet manually as shown here where columns B and C are grouped so they can be hidden This worksheet contains some basic personal spending data and it has totals for income and expenses in columns D and I of the worksheet. Let’s look first at some data that can be outlined automatically. In this article we’ll illustrate and walk through the process of using the Outline tools in Excel 2007 to summarize worksheet data.Įxcel contains an automatic outline tool that works well in most cases, but if your data doesn’t lend itself to automatic outlining you can also create an outline manually. This function allows you to shrink data down to more manageable quantities so that you can see the bottom-line result rather than all the items and pieces that go into making it. There are a number of ways to do this in Excel, one of which is to use Excel’s built-in outlining function. ![]() ![]() When you have a lot of data in an Excel worksheet it often becomes necessary to summarize the information to get to the crux of what it is telling you. With an outline in place, you can click the + and – markers to display or hide parts of the worksheet data
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |