Hi,
sometimes when I type a formula into a worksheet that refers to a cell on another worksheet, when I press enter (or ctrl+shift+enter) it enters the formula into the same cell, but in the sheet the formula refers to.
To me this seems like truly odd behaviour on the part of excel. Is there something I am doing wrong?
sometimes when I type a formula into a worksheet that refers to a cell on another worksheet, when I press enter (or ctrl+shift+enter) it enters the formula into the same cell, but in the sheet the formula refers to.
To me this seems like truly odd behaviour on the part of excel. Is there something I am doing wrong?
