Skip to main content
Question

Title: New User Question: Rows Being Inserted in the Middle Instead of the Bottom in Google Sheets

  • February 20, 2026
  • 0 replies
  • 0 views

Hellen54302
Forum|alt.badge.img+2

Hi everyone! 👋

I’m running into a weird behavior when working with Google Sheets and wanted to see if anyone here has ideas or has run into something similar.

Every time I add a new row manually (or via automation), the new row is not being added at the bottom of my sheet — instead it’s always inserting at row 1257, pushing all existing rows below that down. I expected new rows to be added to the end of the data range.

Here’s what I’ve noticed so far:

  • The sheet definitely has data below row 1257.

  • New rows always appear at 1257, not at the lowest existing row.

  • I’m working either manually or via a script/automation (could be Apps Script/Zapier/Make/Webhook).

Has anyone seen this happen before?
Does anyone know what settings, filters, named ranges, scripts, or other quirks might cause Sheets to treat row 1257 as “the end” of the sheet?

Happy to provide screenshots or more context if needed. Thanks in advance! 😊