Grouping and ungrouping in a password-protected worksheet

[scburgan]

Hello,

I am using MS Excel 2010.


I would like to use the Group function (located on the Data ribbon) to hide and unhide rows. But, after I have password-protected the worksheet, this function is disenabled. I can hide and unhide individual rows, but I can’t do that with the Group function.


Is there a workaround for this?


Thanks,

Steve

 

[SirJB7]

Hi, scburgan!


First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.


As a starting point I'd recommend you to read the green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).


Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.


Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.


And about your question...


I think there are no workarounds you can use without getting involved with macros or VBA code.


Regards!

 

[Balaji.N]

Dear Sir

i have some clarification on grouping functions for which i have to generate

1 sales report

2 calculate age analysis

3 Why Sub total function is used

plz help me on the subject attached excel sheet for your ref.


snos CodeNameageDateproduct Car sales amount
122jagan2824-01-2010jee 22223
233varun2525-02-2010doge 33332
322mnam3320-03-2010chry 34555
455sasikant2520-04-2011doge 5555
522mani3320-06-2011chry 6666
633jagan2820-06-2012jee 66678
722varun2520-07-2012doge 8876
823jagan2820-08-2013jee 667785
922mnam3321-09-2013chry 44355
Total Sum890025

Regards
N.Balaji

 

[SirJB7]

@Balaji.N
Hi!
Would you please start a new topic instead of writing on another user's one? It might be seen as hijacking. More indeed when it's such and old topic. If needed you could add a reference in your new one.
Perhaps you'd want to read the first sticky forum contents so as to know the guidelines that will lead to know how this community operates (introducing yourself, posting files, netiquette rules, and so on).
http://chandoo.org/forum/forums/new-users-please-start-here.14/Regards!
PS: Please don't answer here at this thread.

EDITED

PS2: Crossposted.
http://chandoo.org/forum/threads/change-date-formula-without-vba-use.6589/#post-77142