KeyBoard Shortcuts !

Hey Guys, back after a break.

I have found some new Keyboard shortcuts to Ease-up your excel life and save you some time to stretch your legs,

These shortcuts will come in handy when you will be editing sheets.

Editing Sheets
Inserts a row above the active cell.	Alt+I+R	Keep Pressing F4 or Ctrl + Y for adding multiple rows
Inserts a column to the left of the active cell.	Alt+I+C	Keep Pressing F4 or Ctrl + Y for adding multiple Columns.
Apply Border for Selected cell	Alt+H+B	You wil get further keyboard buttons to press depending on what type of borders you wants
For Highlighting the selected Cells.	Alt+H+H
For changing font color of the cell.	Alt+H+FC

Keep In touch, more interesting tricks and tips coming soon.

Follow my blog and share it with others as well.

Thanks,

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,

The Match Function !

This function looks for an item in a list and shows its position. It can be used with text and numbers.

It can look for an exact match or an approximate match.

Syntax is

=MATCH(lookup_value, lookup_array, [match_type])

Meaning

=MATCH(WhatToLookFor,WhereToLook,TypeOfMatch)

The TypeOfMatch either 0, 1 or -1.

Using 0 will look for an exact match. If no match is found the #NA error will be shown.

Using 1 will look for an exact match, or the next lowest number if no exact match exists.

   If there is no match or next lowest number the error #NA is shown.
   The list of values being examined must be sorted for this to work correctly.

Using -1 will look for an exact match, or the next highest number if no exact match exists.

   If there is no exact match or next highest number the error #NA is shown.

   The list must be sorted for this to work properly.

I hope you find this function helpful,

Keep visiting for more knowledge on excel.

Cheers !