![Rows Rows](/uploads/1/2/5/3/125377274/329625959.png)
![Collapsing Collapsing](/uploads/1/2/5/3/125377274/643473440.png)
Nenshad wrote: hi SGIII, in Excel if you have row 1 titled as expenses and a list of expenses in rows 2 till 10. You can select rows 2-10 and click on data and then click group rows. This will add a '+' sign to the left of the row numbers and you can then click on it to contract rows 2-10 and only view row 1 which says expenses or if you wanted a detailed list of the expenses you would again click on the '+' sign and it would expand row 2-10. It's like what used to be called (don't know how many versions ago) 'outline.'
Excel expert Dennis Taylor helps Excel 2016 users take their spreadsheet skills to the next level with this collection of tips and tricks.
Numbers 3 doesn't have that (though Numbers 2 had something similar called Categorize). How about hiding and unhiding rows as needed?
That does basically the same thing as group and is almost as convenient. Select the rows, move the cursor to the row numbers on the left, right-click, and choose from the drop-down menu. There are some ways to do similar things to Excel's grouping but the correct one to use depends on what you are trying to do, whether you change these groups often, whether you create/remove groups often, etc. A few ideas have been provided already, Here is another: Use a column that will indicate which rows you would like to show. Set up a filter to show only those rows when the filter is on.
In the screenshot below, I used the header column and the word 'total' for the filter. The header row will always show, it is not affected by the filter. EDIT: I haven't used Numbers in a while and didn't realize there is a feature I hadn't used before. Instead of setting up a filter like I showed above, you can right click on a column letter and choose 'Filter Table' followed by clicking on which term(s) you want to filter. You turn it back off by clicking on them again. It basically does the same thing as what I showed above but doesn't require the Filter side panel to be open. And my first idea is below.
Unfortunately numbers falls short of excel as far as the grouping and auto-filtering is concerned. It is a pity because they are the most used excel features. To answer the question of what one is trying to do, it is simply to easily be able to 'Collapse' (hide) column or rows, yet, still have all the information in one table. Consequently, in my wife's business she has 3 rows relating to the parents info, 3 relating to the students information, 5 regarding the service and at least 9 columns relating to the billing, and at least 2 with additional financial information. 22 columns is a lot to have in one view. However, the information is never needed at the same time. If the excel grouping possibility existed the maximum number of rows filling your screen would be 12, achievable through 3 clicks (each click hiding a group).
Apple Footer. This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the.