The shortcuts are the same, but they work differently when you don't have an entire row or column selected.įor example, Control Shift plus (+) in Windows and Control I on a Mac will display the Insert Dialog, which lets you insert cells by shifting other cells either right or down. You can use both of these shortcuts to insert and delete cells as well, either individually or in groups. You can also use this shortcut to delete multiple rows and columns.
The shortcut is Control -.įirst, select an entire row or column, then use Control minus to delete. The logic for deleting rows and columns is the same. You can insert multiple columns and rows as well, just begin with more than one cell selected. Then insert with Control shift + in Windows, Control + I on a Mac. To select an entire column, Use control + spacebar. This shortcut is the same for inserting columns. Then, to insert a row, use Control shift + in Windows, Control + I on a Mac. You can select an entire row with shift and the spacebar. To start off, if you first select an entire row or column, you can use a single shortcut to insert new rows or columns. In this video, we'll cover shortcuts you can use to insert or delete rows, columns, or cells.
