how to set excel function ?
2011-05-01 7:01 am
I have budget and actual figures every month for 12 months and I want to hide all budget columns to see the acutal figures columns only, I know there is a function in excel to do this, I have seen there is a plus (+) and (-) sign on top of the worksheet but I dont know how to set it, can anyone tell me how to do it? thanks
回答 (2)
2011-05-06 10:00 pm
✔ 最佳答案
I use Excel 2007steps:資料->群組
圖片參考：http://imgcld.yimg.com/8/n/HA06688063/o/701104300151113873432510.jpg
2011-05-01 7:26 am
Either 「sub-total」 or 「pivot table」 may help you about this.
2011-05-03 07:34:20 補充：
About subtotals:
http://office.microsoft.com/en-us/excel-help/about-subtotals-HP005203092.aspx
Demo on using PivotTable reports:
http://office.microsoft.com/en-us/help/demo-make-sense-of-your-data-using-pivottable-reports-HA010337957.aspx?CTT=1
2011-05-03 22:44:36 補充：
循例提醒 :
如解答到你嘅問題, 請不要胡亂刪帖或交付投票。
2011-05-03 07:34:20 補充：
About subtotals:
http://office.microsoft.com/en-us/excel-help/about-subtotals-HP005203092.aspx
Demo on using PivotTable reports:
http://office.microsoft.com/en-us/help/demo-make-sense-of-your-data-using-pivottable-reports-HA010337957.aspx?CTT=1
2011-05-03 22:44:36 補充：
循例提醒 :
如解答到你嘅問題, 請不要胡亂刪帖或交付投票。
收錄日期: 2021-04-13 17:57:49
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20110430000051KK01511