Scroll to the Display section. We get the results below. In Column B we will use a formula to check if the cells in Column C are empty or not.
Tick or untick the rectangle box given to enable or disable the formula bar.
It is also sometimes called the fx bar because that shortcut is right next to it. In the formula bar select the portion of the formula that you want to replace with its calculated value. You may need to enter cell edit mode click into the formula bar or use F2 then enter to get Excel to recognize the format change. Go through the below steps to show or hide the formula bar within the excel sheet.