Skip to main content
Solved

How Do I Add MULTIPLE Rows In A Table


Hi, How can I add multiple rows at once in a table. (This is a function that is super easy in google spreadsheet). AT only allows for one row at a time and I have to keep clicking on the Plus sign. Too much work. I wanna add 100 rows at once. Is that possible?

Best answer by kuovonne

You can add multiple blank records by using the [shift][enter] keyboard shortcut in a grid view. Simply hold the keys down longer to add more records.


You can also add more rows by pasting in information from another spreadsheet.

View original
Did this topic help you find an answer to your question?

3 replies

kuovonne
Forum|alt.badge.img+17
  • Brainy
  • 5987 replies
  • Answer
  • April 17, 2020

You can add multiple blank records by using the [shift][enter] keyboard shortcut in a grid view. Simply hold the keys down longer to add more records.


You can also add more rows by pasting in information from another spreadsheet.


  • Author
  • New Participant
  • 3 replies
  • April 17, 2020
kuovonne wrote:

You can add multiple blank records by using the [shift][enter] keyboard shortcut in a grid view. Simply hold the keys down longer to add more records.


You can also add more rows by pasting in information from another spreadsheet.


Thank you so much 🙂


kuovonne wrote:

You can add multiple blank records by using the [shift][enter] keyboard shortcut in a grid view. Simply hold the keys down longer to add more records.


You can also add more rows by pasting in information from another spreadsheet.


how to do this now? When I press shift enter it opens up the row and goes one space down


Reply