Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Spreadsheets: Transpose in 2 easy steps

Google Spreadsheets: Transpose in 2 easy steps

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

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.

4 thoughts on “Google Spreadsheets: Transpose in 2 easy steps

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

© 2024 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Mar 28th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for a way to create dynamic and interactive digital lessons. The Desmos platform is completely free and allows for any topic to be created or customized.

Exit this pop up by pressing escape or clicking anywhere off the pop up.