To prevent a formula from showing in the address bar in Excel, select the cells you want the formula to be hidden in and select Format from the dropdown right-click menu. Go to the Protection tab in the pop-up window and check Hidden.