Results 1 to 3 of 3

Thread: Teacher's marksheet

  1. #1

    Teacher's marksheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a marksheet with students' names
    in e3 to 36 columns total is put using sum formula
    but suppose i enter a subject then i have to shift sum formula to F3 to F7 but manually
    is there any way that i enter a column or row and put data in that column and sum formula is changed automatically for adding the data in that new coloumn
    plz

    Find sample worksheet
    Attached Files Attached Files
    Last edited by Anmol786; 2014-11-03 at 02:24 PM. Reason: Workhseet is not attached

  2. #2
    Goto Excel Options>Advanced and check the box marked Extend data range formats and formulas, it should then automatically add the formula.

    Or just convert the data to a table (Ctrl-T), that will also carry formulas down).

  3. #3
    Quote Originally Posted by Bob Phillips View Post
    Goto Excel Options>Advanced and check the box marked Extend data range formats and formulas, it should then automatically add the formula.

    Or just convert the data to a table (Ctrl-T), that will also carry formulas down).
    Plz do needful in sample file

    plz

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •