When cells or rows are inserted or deleted in an excel worksheet how are cell reference deletion?

Whenever a new row is inserted, based on the insertion point, the rest of the rows will move down and the reference will be changed accordingly.

Explanation:

Suppose there are 5 columns and ten rows in excel containing the value of student marks from column 2 to 4 in each subject and column 1 contains Student roll number.

There are totally 10 entries in the sheet (number of student = 10) and the column 6 is utilized to calculate total and there is a formula associated to each row to add marks.

When we want to enter another student data below the 5th student, we can insert and the whole row including the formula gets changed thus the reference of formula gets changed. Same is the case for deletion.

okay, so i know we just goofed around in that chat, but ive been like genuinly depressed, like medically depressed for almost 4 years now. i had my first panic attack when i was 8. i woke my mum up and told her i felt like i was in a dream. like i was a goldfish in a bowl, looking at all these things going on around me and feeling . tiny. wort hless. and i now am now 17 y/o. i still feel those emotions daily. life used to go by so quick.like every day i would wake up and just like want to go back to bed cause i always felt like i was in the wrong place. i guess looking back, i was in the wrong state of mind. i took a expensive like nice trip to whyoming with my grandfather and ha ted it. like idk why. i would have loved it now, but i found myself writing in a journal everyday because i would forget what happened the day before, couldnt remember what i ate for like the previous meal. just my memory left me for the week i was there. worst feeling ive ever experienced.

lick on your profile and select log out on that device