Google Sheets keeps doubling my row height when I move to another cell

June 16, 2015 3:24 PM

When I'm using Google Sheets, entering words and strings of words in it, fairly often, when I hit return or tab to move to the next cell, the row height will suddenly double. This happens at least 1/4 of the time now, and it never happened in the past.

It happens pretty much independently of whether I am using tab or return, and independently of what's in the cell, whether it's capitalized or lowercase, one word or many, words alone or words and numbers. It's not related to how many characters I have in the cell, either--it's not like the space is needed in any way. It's driving me nuts and I wish it would stop. Any ideas?

posted by Slinga to Computers & Internet (6 answers total)

This may be useless, but I was getting surprise row enlargement when the font was too big? The row only enlarges when a cell has content, not for blank rows. I selected everything, picked a smaller font size, and no longer got this effect.
posted by zeek321 at 3:27 PM on June 16, 2015

It happens to me. I haven't bothered trying to isolate it to a method of leaving the cell, but I will say that going back in, hitting backspace once, and re-typing the deleted character fixes it.
posted by flibbertigibbet at 3:50 PM on June 16, 2015 [1 favorite]

I've noticed that this seems to happen to me more often when I have used backspace while typing in the cell. Not that you can avoid using backspace, but if I try to be aware of it, I can usually catch it right when I leave the cell and fix it then, so I don't have a bunch of clean up to do later.
posted by polymath at 4:40 PM on June 16, 2015

Same here. I go back into the funky cell and retype the thing and then it goes back to a normal size. Annoying as hell, but it's a doable workaround for me since it only happens intermittently.
posted by bedhead at 9:26 PM on June 16, 2015

Using enter instead of tab to move out of the current cell fixed it for me, but you said you already tried that.
posted by bluesky78987 at 8:06 AM on June 17, 2015

Response by poster: It's apparently related to deleting. If you use backspace in the cell, it usually does it, and if you don't, it doesn't. At least I know what to avoid now.
posted by Slinga at 4:18 PM on August 19, 2015 [1 favorite]