Excel VBA to Display search result in listbox

In case if you have a large list of employee data in a sheet and you want to select one employee details in main sheet based on the employee number. You can put a vlookup table and the details can be retrieved based on id in that table as below. But in case if you cant remember all employee id’s, READ MORE

Excel autocorrect feature and tricks to save time

While typing in excel, you might have seen that excel will do many auto correct functions.  We can customize the autocorrect features in excel as per our requirement. To go to excel autocorrect options, follow the below steps: Click on Office buttonClick on Excel options and thenClick on Proofing Click on AutoCorrect options. It gives various options and you can customise READ MORE

How to insert drop down list in excel

In various web pages and software you might have seen drop down list.This drop down list allows us to select the input without any error. Now let’s see advantages of drop down list and how to insert drop down list in Excel : it will give options to the user to select the input easily and quickly the input given by READ MORE

How to add the developer tab to the ribbon

In case you want to learn macros, vba programming and want to become advanced user of excel, you will have to add the developer tab to the ribbon. By default in excel this will not be added in the ribbon. How to add the developer tab to the ribbon in excel 2007 ? Click on excel Office Button Click on READ MORE

How to find duplicates in excel- 3 ways to check for duplicates

As a part of data analysis , in excel we can find and remove duplicate values. there are different ways to remove duplicates in excel. In this article let us understand how to find duplicates in excel. 3 Different ways to check duplicates: There are three different ways to find duplicates in excel. Conditional formating to find duplicates  Using Remove READ MORE

How to lock cell and protect sheet in excel

Excel provides the facility to protect sheet from updating from users. We can define the cells to be protected and cells to be allowed to be used in the sheet in a same sheet. The cells not protected will be allowed for user for updating the data and the protected cell can’t be altered by the users. The protection can READ MORE

Free Software ITR 1 Sahaj income tax return for AY 2018-19

What is ITR 1 and who can file this. ITR 1 Sahaj form can be filed by individuals with the income up to Rs. 50 Lakhs and with the following income.  Salary or Pension Income Income from one house property ( excluding loss brought from previous year) Income from other sources (excluding winning from Lottery and Income from Race Horses) READ MORE

Hide formulas in excel and protect worksheet from update

The Formula bar shows the formula entered in a cell when the cell is selected. Some time you may want to hide this formula from viewing. You can hide formulas in excel sheet without hiding the results of the formula. By doing this the results will appear without any impact in the cell. But the formula will not be visible in READ MORE