Forum Discussion
Excel
(Your question is a bit ambiguous, albeit accompanied by the image.)
Assuming that the cell you want to edit is the cell that currently contains 9.80%, that text box is telling you to go ahead and enter a different tax rate, if applicable.
Have you tried doing so and been prevented? Or have you not yet tried?
If it's not letting you edit the cell, then the message itself seems out of order. This is presumably a spreadsheet that you got from someone or some place, not a spreadsheet you created. Can you fill us in a bit more on the source, what it is you're trying to accomplish with the spreadsheet?
- mathetesDec 15, 2022Gold Contributor
There's no way somebody else can answer that. There should be; after all, that's what you're being prompted to do. But we don't have the sheet in front of us. That is why I asked you: Have you tried? What happens?
When you say you "got from Excel" what does that mean? Is it one of the templates that Excel offers on this larger website? Which template?
NOW, it occurs to me that it's possible that the sheet is "protected" and if so, if it's been protected without a password, then you can go to the menu across the top, select "Tools", go down to the word "Protection" and try to "unprotect"
IF it's been protected with a password, and IF it doesn't allow you to edit that field, despite the prompt, then it's just another example of a poorly thought out template. Wouldn't be the first.
- keao46Dec 15, 2022Copper Contributor
Hello mathetes,
I included a screenshot of the excel spreadsheet. I am able to edit the cell itself. Meaning I can change the value "9.80%". The question I have is, can I edit/delete the box that says "Enter Tax rate in this cell"
Thank you for your time and understanding.
- peiyezhuDec 15, 2022Bronze Contributorhttps://m.toutiao.com/article/7052923698759664132/?traffic_source=&in_ogs=&utm_source=&source=search_tab&utm_medium=wap_search&original_source=&in_tfs=&channel=&enter_keyword=excel+%E6%95%B0%E6%8D%AE%E6%9C%89%E6%95%88%E6%80%A7 https://www.yiibai.com/excel/excel_data_validation.html this may relative to data validate。