Monday, 13 May 2013

Autosum Feature and Relative Cell Reference

Autosum Feature and Relative Cell Reference:

Excel provides Autosum button in Home Tab (Editing group). This includes 5 commonly used functions sum, average, count, max and min. Using this feature we can avoid typing these five functions. But caution is required while auto-selecting range.

In the given example, autosum is used in cell F2. Now we can place the mouse handle in cell F2 and can copy formula using fill handle(dragging downward), Excel will copy formula to all the below cells. While copying formula cell addresses automatically get changed, this feature is known as relative cell reference.

 

No comments:

Post a comment