PASTE IN EXCEL MOVES FORMULA TO CELL BELOW THE ONE I PASTE IN

Question

HiI have been working on a spreadsheet and copying the formula from one cell to the next.&nbsp; When I now try to paste the formula in a cell when I press enter it puts the answer in the cell below the one I have pasted it in.&nbsp; Ie if I paste it to cell B1 when I press enter it puts the figure in C1.&nbsp; I am then able to move it back to B1

sergeibaklan · Answer

CarolSSF&nbsp;
C1 is not down, it's to the right.
What are your settings here?

carolssf · Answer

SergeiBaklan&nbsp;HiSorry I meant if I am in cell B1 it copies to B2

Forum Discussion

PASTE IN EXCEL MOVES FORMULA TO CELL BELOW THE ONE I PASTE IN

2 Replies

Resources