Today I was reading a Google Sheet which was shared with me as view only. It drove me crazy because neighboring cells blocked what I was trying to read. There is a simple fix for this but it was impossible for me to do because I didn’t have editing rights. I found a round about way to view the information. Luckily in view only one can still copy and paste information. I copied the cell to a Google Doc and it let me view the hidden text.

When working with Google Sheets this is what one has to do for preventing text from being hidden by neighboring a cells. Use the text wrapping tool. Click on text wrapping in the dropdown click on the wrap tool (sideway’s U).