Use bidirectional text in tables in Numbers on Mac
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 cells is based on the current keyboard (selected in the Input menu).
Change text direction in cells
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: Click the table, in the Format sidebar, click the Table tab, then click a Table Direction button at the bottom of the sidebar.
Change the sheet direction: Move the pointer over the sheet title (by default, Sheet 1), click the down arrow that appears, then choose 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.