To insert a single column: Right-click the whole column to the right of where you want to add the new column, and then select Insert Columns. To insert multiple columns: Select the same number of columns to the right of where you want to add new ones. Right-click the selection, and then select Insert Columns.
On your computer, open a spreadsheet in Google Sheets. Select a row, column, or cell. Right-click the row, column, or cell. From the menu that appears, select Insert 1 left, right, above or below.
Excel won't insert a column or row with this specific error message. In this case, Excel thinks that every column or row contains at least one item, so when you try and insert the column/ row, Excel would need to drop the last row or column which may contain valuable data.
Press the Alt key and the = (equals sign) key on your keyboard simultaneously. This will add the SUM function to the selected cell, and automatically select the adjacent cells to use in the sum function.
Tip: Select the same number of columns as you want to insert. For example, to insert five blank columns, select five columns. It's okay if the columns contain data, because it will insert the columns to the left of these rows. Hold down CONTROL, click the selected columns, and then on the pop-up menu, click Insert.
F7 Displays the Spelling dialog box to check spelling in the active worksheet or selected range. Ctrl+F7 performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press Enter, or Esc to cancel. F8 Turns extend mode on or off.
