I have a big problem please i need your help!! When i use (=translate ) i cant translate from English to ( kurdish sorane) i don’t know if the language isn’t added to the program or I’m doing it wrong 🤦🏻♂️ I used (“ckb”) and it doesn’t work
@@alizeeshan9922 u have probably protection on the sheet that doesnt allow to show anything in formula bar. I have a video about this but it s not out. In the meantime: 1. Unprotect the Sheet: Go to the Review tab on the Ribbon. Click on Unprotect Sheet. If a password was used to protect the sheet, you will be prompted to enter it. Enter the password and click OK. Once the sheet is unprotected, you should be able to see the data or formulas in the formula bar when you select any cell. 2. Remove Protection from Specific Cells: If you want to remove protection only from certain cells (but leave the rest of the sheet protected), here’s how to unlock those cells: Select the Cells: Highlight the cells from which you want to remove protection. Open Format Cells: Right-click the selected cells and choose Format Cells. Go to the Protection tab. Uncheck "Locked": Uncheck the "Locked" box. This will allow these cells to remain editable and visible in the formula bar when the sheet is protected, while the rest of the sheet remains protected. Protect the Sheet Again: Go to the Review tab and click Protect Sheet again to reapply protection if necessary (this time the selected cells will not be locked).
For more content like this, subscribe😊: th-cam.com/users/excelwizardinminutes?submission=1
Awesome video. Thank you so much!! This was a big help!
Welcome!😊
I have a big problem please i need your help!! When i use (=translate ) i cant translate from English to ( kurdish sorane) i don’t know if the language isn’t added to the program or I’m doing it wrong 🤦🏻♂️
I used (“ckb”) and it doesn’t work
try "ckb" for the to language and let me know if it works
Sir please tell me how to show translate option in farmula bar, in my excel there is not showing formula
@alizeeshan9922 i did not get ur question. U meant that ur formula bar is blank? And u dont see anything u type there?
@EXCELWIZARDINMINUTES Yes sir When i type =translate" translate formula doesn't show up
@@alizeeshan9922 u have probably protection on the sheet that doesnt allow to show anything in formula bar. I have a video about this but it s not out. In the meantime: 1. Unprotect the Sheet:
Go to the Review tab on the Ribbon.
Click on Unprotect Sheet.
If a password was used to protect the sheet, you will be prompted to enter it. Enter the password and click OK.
Once the sheet is unprotected, you should be able to see the data or formulas in the formula bar when you select any cell.
2. Remove Protection from Specific Cells:
If you want to remove protection only from certain cells (but leave the rest of the sheet protected), here’s how to unlock those cells:
Select the Cells: Highlight the cells from which you want to remove protection.
Open Format Cells:
Right-click the selected cells and choose Format Cells.
Go to the Protection tab.
Uncheck "Locked":
Uncheck the "Locked" box.
This will allow these cells to remain editable and visible in the formula bar when the sheet is protected, while the rest of the sheet remains protected.
Protect the Sheet Again:
Go to the Review tab and click Protect Sheet again to reapply protection if necessary (this time the selected cells will not be locked).