Most formula you create including references to cell or ranges . These references enable your formula to work dynamically with the data contained in those cells or ranges rather than being restricted to fixed value . For example, if your refers to cell A1 you change the value contained in A1 , the formula result changes to reflect new value . If you didn't use references in your formula , you would need to edit the formulas themselves in order to change the value use in the formula . there are mainly four type of cell references. Relative cell reference it refers to the cell by their position in relation to the cell that contains the formula . The row and column references can change when you copy the formula to another cell because the references are actually offsets from the current row a...
A new feature in Excel 2013,Flash fill can enter data automatically into your worksheet.It can save your time and effort .flash fill can guess what kind of information you're entering into your worksheet. Flash fill can finish your work for as soon as it detect what you want to do. Shortcut key: ctrl+E process of how to turn on flash fill Flash fill can automatically fills your data when it sense a pattern for that you need to turn on flash fill. go to file ￫ option click on a dvanced and make sure the automatically flash fill box is checked. Example 1 In the below picture we have to write First Name ,Middle Name and last name separately . Here we can use flash fill . First ,let the Excel know what you want to do by entering the "rohan" into cell B3"kumar" into cell C3 and "jaiswal"into D3. Go to the Data tab ￫ click Flash Fill or(press Ctrl+E) Result Example 2 Here we have to write separately state code ,pan card and z...