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 button Click on Excel options and then Click on Proofing  Click on AutoCorrect options. It gives various options and 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

How to use excel cell function

Version in which excel CELL function can work: Excel CELL function will work in Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Starter 2010. About READ MORE