2

I've been using Google Sheets in List View (View->List View on the menu bar) as I have a fixed number of columns in my spreadsheet.

I'd like to add new rows to the end of the List instead of at the top of the list, but when I click the +Add button, it puts the new row at the top of the list instead of the bottom.

Is there anything I can do to change this functionality, so that new rows appear on the bottom of the list? (other than use Spreadsheet View of course).

closed as off-topic by pnuts, ale, serenesat, jonsca Aug 18 '17 at 23:58

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions on applications or application features that are no longer available are off-topic for Web Applications as no one will ever be able to make use of the answers again." – ale, serenesat, jonsca
If this question can be reworded to fit the rules in the help center, please edit the question.

  • "View->List View" doesn't seem to be a valid option... – Pacerier Jul 25 '14 at 2:02
  • I asked this question in 2010, I'm sure Google has changed it by now. – leeand00 Jul 25 '14 at 13:50
  • 1
    perhaps you should edit or delete the question... – Pacerier Jul 25 '14 at 15:04
2

When I tested this myself, the fields to enter new data showed above the list, but when I clicked Submit, the row was sent to the bottom of the list and I got the message, "New row added. Jump to last page to view it." Are you seeing something different?

It makes sense for the new data fields to appear near the + Add button, because that is where your focus is.

Not the answer you're looking for? Browse other questions tagged or ask your own question.