How To Turn off Group Mode in excel/How to make un group your excel


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. 

 Your Data Tab(Filter) will be inactive mode

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.



Author: Pavithra Damodhan

Hello, I am Author, decode to know more: In commodo magna nisl, ac porta turpis blandit quis. Lorem ipsum dolor sit amet, consectetur adipiscing elit. In commodo magna nisl, ac porta turpis blandit quis. Lorem ipsum dolor sit amet.

0 comments:

E-mail Newsletter

Sign up now to receive breaking news and to hear what's new with us.

Recent Articles

© 2014 Howto- Excel | Distributed By My Blogger Themes | Created By BloggerTheme9
TOP