Hello Geeks,let me give a example how i create this post.Yesterday i used multiple excel at once,suddenly my data tab (filter) gone inactive. it was Oops moment for me to get rid immediately.than i saw its was in group mode which i selected multiple sheet !!!!. I thought this will happen to many who works in multiple sheets.so here are the solution.please check the step by step pictures to learn.
When my Excel Ungroup Data Tab is active ( Filter options works fine)
By mistake you would have select all sheets using shortcut keys(Ctrl+Shift+Click)
This is how your excel mode will be shown at top if you select all sheets (or) multiple sheets.
The very simple step just right click on one of the sheet uncheck (ungroup sheets)
Thats it,your excel will be normal mode as like before.just put a comment if this post helped you.
0 comments:
Post a Comment