Hi, I have create a worksheet "Daily Expenditure" containing groups and outline to record my daily datas.
For ex: Group name is 'car maintenance', under this group, i have petrol, carpark, car wash, servicing, modifications....
Another group name is "personal care", under this group, i have hair gel, shower gel, hair cut, shaver blades, hair cream... and so on
Within the worksheet, I have inserted sheets for all the months in year 2011. In sheet, January, I will click/select the whole page(between row 1 and column A) copy ---> go to sheet February ---> paste. By right, the page format should be the same as january with correct group and outline.
But, recently, when i copy and paste between sheets, the result is different. The new sheet will show all the groups become expanded and ungroup. meaning i can see all the outline without any groups.
I tried on ms office 2007 and 2010. both are having the same problem. Can someone pls help? Thank you
For ex: Group name is 'car maintenance', under this group, i have petrol, carpark, car wash, servicing, modifications....
Another group name is "personal care", under this group, i have hair gel, shower gel, hair cut, shaver blades, hair cream... and so on
Within the worksheet, I have inserted sheets for all the months in year 2011. In sheet, January, I will click/select the whole page(between row 1 and column A) copy ---> go to sheet February ---> paste. By right, the page format should be the same as january with correct group and outline.
But, recently, when i copy and paste between sheets, the result is different. The new sheet will show all the groups become expanded and ungroup. meaning i can see all the outline without any groups.
I tried on ms office 2007 and 2010. both are having the same problem. Can someone pls help? Thank you