Show All Comments in Google Sheets

The ability to comment on cells in Google Sheets is super useful.  The ability to find those comments, however . . . pretty stinkin’ difficult.  That little yellow triangle in the corner just ain’t cutting it.  In a big spreadsheet, it can be easy to miss some comments.

You can show all of the comments in the currently open spreadsheet tab by either hovering over or clicking on the comments icon on the sheet tab at the bottom.  Clicking keeps them open while you move your mouse around or scroll.  If you hover, the comments are hidden again as soon as you move your mouse.

Show All Comments in Google Sheets Animation

Published by

Jake Miller

Jake is a Google for Education Certified Trainer and is the Lead Technology Integration Specialist for Brady Middle School in Ohio's Orange City Schools. In the past he taught STEM, Science & Math in Stow-Munroe Falls, Ohio, where he was also a leader in the district's Technology Leadership Team and a co-advisor for the middle school's STEM Club. He has been an educator since 2003. His Bachelor's Degree is in middle-level education (math/science) from the University of Akron and his Master's Degree is in Instructional Technology from Kent State University. He has enjoyed providing more than 100 professional development opportunities at conferences and school districts across the state of Ohio. He is very involved in Twitter (@JakeMillerTech) and provides regular pointers for educators with his #GAFETip tweets.