Adjusting/Aligning Text in One Cell !

Sometimes we need to type something in excel which doesn't fit in one cell, It automatically comes in front of the other cell thus making the information in the next cell invisible. To avoid this problem,
simply follow the below mention steps:

1. Right click on the cell, which contains the information and then click on Format cell, or simply press Ctrl+1 to open the format cell dialogue box.
2. Click the Alignment tab in the dialogue box, next to Numbers tab.
3. In the Alignment Tab go to Vertical and select Justify by clicking on the Drop down button.
4. Click Ok and your work is done.

Your Comments and Feedbacks are of high value to me.

Keep Visiting and Sharing.

Best Regards,

Remove Formula's from Your Excel Sheet !

Sometimes you don't want to let know, how hard you had to think about formula's to get a task done in excel and will never want to share it with others. Or due to maximum use of formula's in a single sheet, it has gone extremely heavy in size which can cause you trouble in presenting it to your authorities.

Well, There is a very simple way of getting rid of all the heavy duty formula's without tempering your data.

1. Copy the cells that contain the formula's by pressing Ctrl+C or by clicking the copy button in the clipboard section of home tab.
2. Go to paste options in the home tab
3. Click the drop down arrow
4. Click the 123 button in Values section.

This will remove the formula from the cell and will leave the values only that were calculated through the formulas.

Keep Visiting and sharing these interesting excel tips to others.

Best Regards,

Find New Customers From Month’s Sale Data | Conditional Formatting – Making Things Happen.

Conditional Formatting is helping us from last 8 to 9 years. A well designed data Analysis & Presentation Tool created by Microsoft to enhance User Experience. Everyone has different way to work with Conditional Formatting but good thing is that it is so simple to use even it so powerful. Lets See how can conditional formatting helps us to find new customer in a list.

Read More





Best Regards,

Remove Duplicate Values in Excel !

In the previous post i told you guys how to highlight duplicate data, now i will be showing you guys how to remove the duplicate values, the easy way.

Select the Column or Columns on which you want to apply the Remove duplicate option.

1. Go to the Data tab in the ribbon
2. Click Remove Duplicates in the Data Tools section.
3. A window will pop-up shown you the columns that have been selected for this operation.
4. Click Ok and there it is, a Dialogue box will appear showing the details of how many duplicate entries were removed.

Keep visiting for more interesting excel options which can make your life a-lot easier.

Comments and suggestion are welcomed.

Best Regards,

Highlight Duplicate values in Excel !

If you are working on a large data sheet and you want to check if there are any duplicate entries or values in it, then simply,

Select the Row or Column in which you want to highlight duplicates.

1. Go to Home
2. Conditional Formatting
3. Highlight Cells Rules
4. Duplicate Values

This will highlight all the values that are being repeated. Cheers !
Stay Tuned,
Soon i will tell you guys, how to Remove Duplicates from your data.


Best Regards,