Monday, February 24, 2014

Make your Google Spreadsheets EASY to Read!

I use Google Forms all the time because I love the fact that the information 
automatically populates into a spreadsheet as people complete the form.  
It is the easiest way I know of to quickly gather information from people, 
without having to type it all in myself. 

The only thing I don't love is that if the form has many questions, 
I have to scroll and scroll and scroll and scroll for a sweet forever
to read all of one person's responses.  

But not anymore! 
I just found a way to quickly transpose rows and columns in a 
Google Spreadsheet and it makes all the difference in the world!  

1. Open your Google Spreadsheet.

2. At the bottom left of the page, click the plus sign to create a new sheet. 
3. On the new sheet, click in the very first cell (A1) and paste this formula and click Enter after you make the changes below:
=TRANSPOSE( 'Sheet1'!A1:Z )
  • If your first sheet is NOT titled Sheet1, replace the words Sheet1 with the name of the sheet or rename the sheet (by right clicking on the name and choosing rename from the drop down). 
  • You can replace the Z with the last column you have on your spreadsheet but you don't have to unless if you have more than 26 columns.
As soon as you click enter, the information will populate on the sheet in a much easier to read format! 

How cool, and easy to read, is that? 

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...