> Is it possibble in excel to change the red circled number 5 to number 4 so whole table begins from 4?

Is it possibble in excel to change the red circled number 5 to number 4 so whole table begins from 4?

Posted at: 2014-12-18 




Assuming that the person who constructed the table used the obvious methods of using relative addressing to copy the relevant equations across the range of cells used in constructing the table, it is straightforward:

It would work simply by ensuring that the contents of

cell A5 are made to be:

= E2

.....and in use, the contents of E2 would presumably be entered manually as and when needed ( e.g. by clicking into cell E2 then typing 4 into cell E2 to achieve what you ask for ).

A cursory inspection of your image suggests that the other cells would probably already contain something like:

. . . A . . . . . B . . . . . C . . . . . D . . . . . E . . . . . F . . . . . G

5 =E2 . . . . . . . . . =A5^2 . . . . . . . =A5^3 . . . . . . . etc . . . . . . .

6 =A5+1 . . . . . . . =A6^2 . . . . . . . =A6^3 . . . . . . . etc . . . . . . .

7 =A6+1. . . . . . . .=A7^2 . . . . . . . =A7^3 . . . . . . . etc . . . . . . .

8 =A7+1. . . . . . . .=A8^2 . . . . . . . =A8^3 . . . . . . . etc . . . . . . .

. . . etc. . . . . . . . . . . etc. . . . . . . . . . etc. . . . . . . .

and the calculated contents of those cells would then automatically update as soon as the contents of cell E2 are changed.

Note, however, there are several other ways of efficiently achieving the same results, some using combinations of relative and absolute cell addressing (which can have advantages when constructing the formulae that are being copied).

I don't know how to do it but I think it is possible