Forum Discussion
M0stqfa
May 23, 2023Copper Contributor
Type Arabic text and numbers in excel sheet
Excel used to have advanced setting that allow context typing in the whole sheet. i.e. when I write Arabic alphanumeric it is writing Arabic letters with English numbers.
إجمالي قيمة العقد 1500000 الف جنيه |
Instead of
any help with regards to changing context for the whole sheet!?
5 Replies
Sort By
- umtkynCopper Contributor
- NikolinoDEGold Contributor
Maybe these links will help you more.
Type Arabic text and numbers in excel sheet1
Type arabic text and numbers in excel sheet 2
They can be seen on the right when opening the message.
- umtkynCopper Contributorthanks for the fast reply...
first link is this thread...
the second one i have already but not no result...
- NikolinoDEGold Contributor
To enable context typing for Arabic text and numbers in Excel, you can change the text direction and enable the right-to-left option for the entire sheet.
Here's how you can do it:
- Select the entire worksheet by clicking on the select all button at the top-left corner of the sheet (the button with a triangle pointing down and to the right).
- Right-click on any selected cell and choose "Format Cells" from the context menu.
- In the Format Cells dialog box, go to the Alignment tab.
- In the Text Control section, select the option "Right-to-left" under the Text direction drop-down menu.
- Click OK to apply the changes.
By enabling the right-to-left text direction for the entire sheet, you can enter Arabic text and numbers in their proper context, with Arabic letters and Arabic numerals aligned correctly.
Please note that this setting will affect the entire worksheet, so make sure it's what you want for the entire sheet. If you have specific sections within the sheet where you want to type in a different text direction, you can select those specific cells or ranges and apply the formatting individually.
You can switch between different keyboard layouts using the language bar or keyboard shortcuts specific to your operating system.
Here are the keyboard shortcuts commonly used to switch between keyboard layouts or input languages in different operating systems:
Windows:
- To switch between languages: Left Alt + Shift
- To cycle through installed keyboard layouts: Left Alt + Shift or Ctrl + Shift
Mac:
- To switch between languages: Command + Space
- To cycle through installed keyboard layouts: Control + Space or Option + Space
Linux (GNOME desktop environment):
- To switch between languages: Super (Windows key) + Space
- To cycle through installed keyboard layouts: Super (Windows key) + Space or Ctrl + Space
Please note that these shortcuts may vary depending on your specific operating system configuration or any customizations you have made. It's always a good idea to check your system settings or keyboard preferences for the exact shortcuts applicable to your setup.