Excel Shortcut For Insert Row How To Insert Rows

Whether you want one or ten, above or to the right, heres how to insert rows and columns into Sheets.

Open a spreadsheet in which you want to insert a few rows or columns.

You can insert rows above or below and columns to the left or right of the selected cell.

For example, highlight two vertical cells to insert two rows or highlight two horizontal cells to insert columns.

Highlight the cell you want to insert them next to, right-click the selection, and then choose Insert Rows or Insert Columns.

Select the cell, as you did before, and then press one of the shortcuts to insert a row or column.

If youre using Chrome on Windows, Linux, or Chrome OS, use the shortcut for Chrome.

If youre using a different browser, follow the other browser-specific commands.

Highlight the cells from the row or column you want to remove, and then press the keyboard shortcut for the command you want to execute.

Hes covered everything from Windows 10 registry hacks to Chrome browser tips.

Since we launched in 2006, our articles have been read more than 1 billion times.

Excel Shortcut For Insert Row Mac