Today Google announced some new features for Google Sheets on their blog. Many of the new features are exciting, but one I am particularly excited about is “paste transpose.” One feature of Excel that I use a lot is to paste special and transpose cells, unfortunately this was not a feature in Google Sheets, until now. 


Transpose is to switch from horizontal to vertical or vice versa. In other words from rows to columns (or columns to rows.).

Step 1

Copy a list of either vertical or horizontal cells.

Step 2

Right click in a blank cell. Choose paste special and paste transpose.

Notice the list of names now goes across the cells.

Go slow with Brownell

Go Slow Online Workshop

Math Recess with Dr. Chris Brownell.