anything in Excel...

It's Excel-o-lozy...

ProTrick - Search / Find a Sheet / Tab by its name...

"simple... Ctrl+F... "

I knew it, thats what comes to mind if we wish to search/find something.

But I am talking about finding / searching a "Sheet / Tab" by its Name or a part of Name...

Easy job?

Ok, Think that you have to find a sheet in a workbook of 50 sheets and you don't know the Full Name and there are 30 sheets of similar name.

Now tell me... HOW???

Ctrl+F????

No??? hmmmm.... ahmm.... 1 sec... no... no...

Keep thinking... till I be back with an answer...

and I know you guys gonna kill me as my last post too had similar quiz...

No worries, I ll answer both...  c ya...

0 comments: