NOTE: You can use the Undo button to restore deleted or cleared rows as long as the sheet has not yet been saved. To clear the content of a row without deleting the row, click on the row's number and then press Backspace or Delete. You can also insert or delete multiple rows at a time: To delete a row, click the drop-down arrow to the right of the row number and select Delete Row.Ī sheet can contain up to 20,000 rows, 400 columns, or 500,000 cells (whichever limit is reached first). TIP: You can also select a cell in a row and press Insert (Windows) or Control + I (Mac).
A new, blank row will be inserted above or below the selected row as per your selection. To insert a single row in a sheet, right-click on a row number and select Insert Row Above or Insert Row Below.
