To stop the worksheet name from coming automatically while referring a cell or range of cells
How to stop the worksheet name from coming automatically while referring a cell or range of cells in same worksheet in the same workbook in excel 2016 for eg refer to cell B5 of the attached excel file....here instead of "=B3+B4" the formula is taking as "=Sheet1!B3+Sheet1!B4" automatically and I have to change it manually. If I am referring to other worksheets then its ok, but in the same worksheets it creates confusion. It occurs mostly in cases of terms of the formula appearing after a term which is referred to in some other sheets. For eg "B3+B4" will come in normal notations if the formula is written in sheet1 and both "B3" and "B4" cells referred here are in sheet1 but "Sheet2!B3+Sheet1!B4" will be the weird version of the formula even if you are writing the formula in sheet1 with reference to cell "B3" in sheet2 (for which the notation is ok) and B4 in sheet1 (for which the notation is bit unusual) I hope you understand. So if anyone can advice how to stop this from occurring it will be helpful. Thanks....