/docs/community?hl=en
This content is likely not relevant anymore. Try searching or browse recent questions.
This post is a trending issue.
-
Google Sheets automatically adds newline when editing cell 5 Recommended Answers 117 Replies 429 Upvotes
1 Recommended Answer
$0 Recommended Answers
I've noticed a new bug in the past couple of days that's getting a little bit annoying.

So in Google Sheets if you click to edit a cell (or press enter to edit) and backspace it's contents until it's blank, it automatically adds a newline (as if you clicked Ctrl + Enter) after you press enter, tab, click away, or stop editing in whatever way. It also adds the newline even if you add more data back in after clearing it. It doesn't happen if you edit the cell through the formula bar, though.

I've tested this on multiple windows computers, on Firefox, Edge, and Chrome. It does not happen on Chrome.
All Replies (117)
Hey Alex - thanks for posting this!

Yep, have noticed the same issue.  It's driving me nuts.

Reiterating Issue:
When entering contents into a cell and pressing enter the cell appears with the contents entered as well as an additional line below.  This results in the row auto formatting to include an extra row to accommodate seemingly blank space.  This changes the formatting of the document until selecting that cell and pressing delete or backspace after the contents of the cell then pressing enter again.

As a dedicated firefox user (sorry chrome) this is frustrating to deal with constantly.
Looking forward to the bug fix.
marked this as an answer
Yes, I'm confirming what you describe is happening in my Firefox, but not in Chrome.
 
I'll escalate the issue through my channels, but just so you know, I'm not a Google Employee, and all I can do is send a message. I don't usually get an actual response, but that, down the road, the issue gets resolved.
 
Meanwhile, I recommend that you submit the issue through the in-product feedback tool.
 
Best,
Lance
marked this as an answer
I recall this being an issue several years ago (I do not recall which platform we were using at the time).  It was eventually sorted out.  So disappointed (and very annoyed) to see it back again.
marked this as an answer
I'm experiencing the same issue with Firefox. I can sometimes see a new line being added to a cell automatically, but then can't remove the line.
marked this as an answer
This question is locked and replying has been disabled.
Discard post? You will lose what you have written so far.
Write a reply
10 characters required
Failed to attach file, click here to try again.
Discard post?
You will lose what you have written so far.
Personal information found

We found the following personal information in your message:

This information will be visible to anyone who visits or subscribes to notifications for this post. Are you sure you want to continue?

A problem occurred. Please try again.
Create Reply
Edit Reply
Delete post?
This will remove the reply from the Answers section.
Notifications are off
Your notifications are currently off and you won't receive subscription updates. To turn them on, go to Notifications preferences on your Profile page.
Report abuse
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
Report post
What type of post are you reporting?
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
This reply is no longer available.
/docs/threads
//accounts.google.com/ServiceLogin
You'll receive email notifications for new posts at
Unable to delete question.
Unable to update vote.
Unable to update subscription.
You have been unsubscribed
Deleted
Unable to delete reply.
Removed from Answers
Marked as Recommended Answer
Removed recommendation
Undo
Unable to update reply.
Unable to update vote.
Thank you. Your response was recorded.
Unable to undo vote.
Thank you. This reply will now display in the answers section.
Link copied
Locked
Unlocked
Unable to lock
Unable to unlock
Pinned
Unpinned
Unable to pin
Unable to unpin
Marked
Unmarked
Unable to mark
Reported as off topic
/docs/profile/0?hl=en