Question

Write the shortcut keys to insert a row and a column

Answer 1

select an entire raw/column that you want add a raw/column above or left of it, and then press Ctrl + + keys

Answer 2

Answer:

the shortcut keys to insert a row and a column

Explanation:

#1 – Select Entire Row or Column

Shift+Space is the keyboard shortcut to select an entire row.

Ctrl+Space is the keyboard shortcut to select an entire column.

Select Entire Row or Column in Excel Keyboard Shortcuts

The keyboard shortcuts by themselves don't do much. However, they are the starting point for performing a lot of other actions where you first need to select the entire row or column. This includes tasks like deleting rows, grouping columns, etc.

These shortcuts also work for selecting the entire row or column inside an Excel Table.

Keyboard Shortcut to Select Rows or Columns in Excel Table

When you press the Shift+Space shortcut the first time it will select the entire row within the Table. Press Shift+Space a second time and it will select the entire row in the worksheet.

The same works for columns. Ctrl+Space will select the column of data in the Table. Pressing the keyboard shortcut a second time will include the column header of the Table in the selection. Pressing Ctrl+Space a third time will select the entire column in the worksheet.

You can select multiple rows or columns by holding Shift and pressing the Arrow Keys multiple times.

Select Multiple Columns with Shift Plus Arrow Keys

#2 – Insert or Delete Rows or Columns

There are a few ways to quickly delete rows and columns in Excel.

If you have the rows or columns selected, then the following keyboard shortcuts will quickly add or delete all selected rows or columns.

Ctrl++ (plus character) is the keyboard shortcut to insert rows or columns. If you are using a laptop keyboard you can press Ctrl+Shift+= (equal sign).

Insert Entire Row in Excel

Ctrl+- (minus character) is the keyboard shortcut to delete rows or columns.

Delete Selected Column in Excel

So for the above shortcuts to work you will first need to select the entire row or column, which can be done with the Shift+Space or Ctrl+Space shortcuts explained in #1.

If you do not have the entire row or column selected then you will be presented with the Insert or Delete Menus after pressing Ctrl++ or Ctrl+-.

Insert or Delete Menu Appears When Entire Row or Column is Not Selected

You can then press the up or down arrow keys to make your selection from the menu and hit Enter. For me it is easier to first select the entire row or column, then press Ctrl++ or Ctrl+-.

So, the entire keyboard shortcut to delete a column would be Ctrl+Space, Ctrl+-. You could also use the keyboard shortcut Alt+H+D+C to delete columns and Alt+H+D+R to delete rows. There are lots of ways to do a simple task…

... hope it helps...