How To Write Vertically In Google Sheets

In this blog post, we will uncover a step-by-step guide on how to write vertically in Google Sheets. This feature can be incredibly helpful when dealing with large datasets or when you need to format your data in a particular way.

Step 1: Open Your Google Sheets Document

The first step is to open your Google Sheets document. You can access Google Sheets by either opening a new tab in your browser and typing in “Google Sheets,” or by going directly to Once there, select the document where you want to write vertically.

Step 2: Select the Cell(s)

The next step is to select the cell or range of cells where you want your text to be vertical. You can do this by clicking and dragging over the cells you want to select.

Step 3: Open the ‘Format Cells’ Dialog Box

Now that your cells are selected, you need to open the ‘Format Cells’ dialogue box. Navigate to the menu bar at the top of the page, click on “Format”, then select “Text rotation”.

Step 4: Adjust the Text Rotation

In the ‘Text rotation’ dialog box, you will see several rotation options for your text. The standard rotation options you will see include:

  • Upward – This option will angle your text up from the bottom left to the top right of the cell.
  • 0 degrees – This will return your text to the standard horizontal alignment.
  • Downward – This option will angle your text down from the top left to the bottom right of the cell.

To write vertically, you should select “Stack vertically” option. This will stack your text from top to bottom, meaning you will read from top to bottom.

Step 5: Apply the Changes

Once you have made your selection, click ‘OK’ to apply the changes. The text within the selected cell(s) should now be aligned vertically.


And there you have it! You now know how to write vertically in Google Sheets. This simple but incredibly useful feature can help you better organise and present your data. Happy vertical writing!