Use bidirectional text in tables in Numbers on iPad
Numbers supports bidirectional text in cells, so within the same spreadsheet you can have some cells with text written from left to right (such as in English or Chinese) and others with text written from right to left (such as in Arabic or Hebrew). You can also reverse the direction of the table itself, or of a sheet and everything on it.
Note: To change the direction of cell text, a sheet or an entire table, your device must be set up for input sources that use different text directions — for example, one keyboard for typing a right-to-left language, such as Hebrew, and another for typing a left-to-right language, such as English. If Numbers is open when you add a right-to-left keyboard, you need to restart Numbers before you’ll see the bidirectional controls. See Set up a keyboard or other input source for another language.
The default direction of text in table cells is based on the current keyboard. (You can change your keyboard in Settings > General > Keyboard.)
Change text direction in cells
You can change the direction of text in a cell.
Tap the cell to select it.
Tap , then tap Cell.
Reverse the table or sheet direction
If you reverse the table direction, header rows move to the other side and column order is reversed. If you reverse a sheet, all tables on the sheet, as well as the relative position of all objects on the sheet, are reversed.
Do any of the following:
Change the table direction: Select the table, tap Table Actions, then tap Reverse Table Direction.
Change the sheet direction: Tap the sheet title (by default, Sheet 1), then tap Reverse Sheet Direction.
When you change the direction, cell alignment is affected as follows:
Text cells set to auto-align (the default setting) change their text alignment.
Number cells set to auto-align (the default setting) don’t change their number alignment. (Numbers always auto-align to be right-aligned.)
If a cell’s alignment is right, left or centre aligned, it retains that alignment.
If a cell’s alignment is justified, the gap for a partial line changes from being on the right to being on the left.