How to change Direction for Hebrew/English

Hebrew is written from right to left. How do I change direction in the speadsheet - including the direction of the spreadsheet coulumns

Enable Complex text layout (CTL) under Tools → Options → Language Settings → Languages, you’ll then also get additional font options for Format Character, but also Right-To-Left in the Sheet menu will be enabled to switch column direction. Cell content is automatically written LTR or RTL depending on language/script.