Repeat labels in all Rows

Welcome Readers !

So here is a simple solution to question which many people ask me during my sessions.

Imagine when you get data in form of a pivot Report . As a simple step , you just have to copy and paste this data from pivot in a new sheet and start working on it. But can you use filters ?? Can you use formulas through out ?? The answer is NO .. But why ?? Because the first column that contains some category names ,have it written only on the top row, for others it is blank .. Right ????

So does your data looks something like this ?

Can you notice the Dept Column ? Where Department names are written just once in the top row of its particular group.

So the solution is something very simple

Here you go ...

The only thing you need to do is , Go in the very next cell of the first category name in this column. Here type the formula beginning with equal symbol (=) and select the cell above.
For example in above image, if  'Dept' is written in column 'A' and 'Admin' is written in cell 'A2' , then go in cell A3 and type the formula as =A2 and press enter.

Now copy this cell (In this example cell A3)

Next step in select this entire column and press F5 on your keyboard . This will take you to Go To dialogue Box. Now hit the 'special' button given at the bottom of this dialogue box and select the option as 'Blanks' and click 'OK'.
Can you notice all blank cells in this column are selected. And now nothing , just press Ctrl+ V to paste.

Result : Each row in data has category name written in front of it.

Hope this helps ....

MS Excel

Hi ! So here goes my first post .... The only good thing about me is my Logic and hence, here come the post that introduces that logical app which has become a must known kind of an app these days.. "MS Excel"

The word "Excel" , part of my favorite word "Excellent" has actually become a part of our lives now. Guess all those in KPOs, BPOs, IT and irrespective of the industry , all those doing desk jobs will agree with me. Without knowing Excel , we are missing that gravity .. or to put it in better words the "Apple of the Bosses' eye"  kinda position.

At the very first look , it appears as a simple table where we can easily enter our data.. But it has loads of tools built in that will manage the data , extract all information itself and hence create those highly effective and instrumental reports. Now imagine , what if you do not have to do anything to prepare all these reports. Enter the office early in the morning ... Press a button ... And your work is done automatically. In the evening when you check the system you get all those reports prepared. Yes !!! That's the magic of Excel.

It is easy to press a button , but what is challenging is to make this magic happen .. and I know all of us like challenges.

The attempt out here is just to build a curiosity and a temptation for the application. In my upcoming posts I will update about some interesting and good to know features about MS Excel.

Thanks to Microsoft for building such an application .. And thanks to readers for going through the post..

Good Luck !!