Forum Discussion
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 exce...
That's new for me. How do you insert your formula, just typing in cell edit mode or some other way?
Just typing in cell edit mode....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.
Please see if this can be solved.
