Forum Discussion
arunmukherjee
Nov 12, 2019Copper Contributor
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...
Patrick2788
Nov 12, 2019Silver Contributor
Excel includes the sheet name if you visit another sheet then return to the active sheet.
- arunmukherjeeNov 12, 2019Copper Contributor
Patrick2788 this was not the case for excel 2003 or 2007 versions
- Patrick2788Nov 12, 2019Silver Contributor
I don't have access to Excel 2003 but I can confirm this does happen in Excel 2007.
- SergeiBaklanNov 12, 2019Diamond Contributor
Almost sure that was in oldest versions.