Forum Discussion

celiosilvamt's avatar
celiosilvamt
Copper Contributor
Oct 04, 2024

The ribbon greys out once I enter the egual symbol in a cell to start a formula

Hello Everyone

 

First let me say that I am not proficient in Excel so please if you decide to help me out, please consider that you will be helping someone who is still learning. I had been working on a worksheet for awhile, but all of a sudden , whenever I enter the equal symbol  (=) in a cell to start a formula, all the ribbon options goes grey and I can't use. I already googled and it says that I don't have permission, but its my computer, my worksheet and I am the only one who uses the computer. And I was using before so how come now I don't have permission? Would someone please help? 

Thank you so much.

Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Oct 04, 2024
    This is normal behavior of Excel. Once you start to typing formula in cell then you have to finish it then apply formatting. You can't any format on formula texts but on cells to format formula results. So, don't worry about graying out ribbon option when you type = (equal symbol) into a cell. Enjoy excel!
    • celiosilvamt's avatar
      celiosilvamt
      Copper Contributor
      Oct 04, 2024

      Harun24HR I guess I did not explain it well. When the ribon greys out, it becomes unavailable and I can't use it anymore. Only if I delete the = symbol it becomes available. And it is happening across the whole excel on my computer. I am not able to format any cell in any of my worksheets. I have google about it and tried everything but there is no solution. I am thinking about deleting the software and re-installing to see if works. I thought that some one here would know what to do, but appears it is an issue that nobody know. And btw thank you so much for responding. I sincerely appreciate. I will give it one more day and then I will delete the app from my computer. Thank you again Harun24HR . 

      • celiosilvamt's avatar
        celiosilvamt
        Copper Contributor
        Oct 04, 2024
        Actually I just realized that it will not just not allow me to format cells, even if I type anything in any cell, the ribbon will block out. Harun24HR