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.
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.
Insert column shortcut
Follow these steps for a quick and simple way to add a new column: Click on the letter button of the column immediately to the right of where you want to insert the new column. Press the Ctrl + Shift + Plus sign keys simultaneously on the main keyboard or Ctrl + Plus on the numerical pad.
Press “Ctrl” and then “Space” to select the entire column next to which you want to insert additional columns. While holding “Shift” down, press “→” or “←” one time less than the number of columns you need to insert (e.g., two times for three additional 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.
In the chosen cell, type “=SUM(” and select cells or a range you want to sum up, or by choosing from a list of functions (Go to the “Insert” tab, move to the “Function”, and select “SUM” function. Then, you can manually type in values or input cells or a range by cell reference. Press the “Enter” key on your keyboard.
You can use the VSTACK function in Excel to quickly stack multiple columns into one column.
Merge Cells: It is the art of combining multiple cells of rows or columns into a single cell or columns to a single cell. Various types of Merge options with Shortcut keys to merge cells in excel are as follows: Merge Cells (Excel Shortcut key – ALT H+M+M) Merge & Center (Excel Shortcut key – ALT H+M+C)
Tip: You can select the whole single or multiple columns by selecting the column header letters and right-clicking, then selecting “Insert” from the pop-up option. The number of inserted columns always depends on how many columns you have selected. You can also insert the column from the “Home” Tab Ribbon.
If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you're done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. Here's an example.
Insert the same data into multiple cells using Ctrl+Enter
Select all the blank cells in a column. Press Ctrl+Enter instead of Enter. All the selected cells will be filled with the data that you typed.
Option 1: Right-click on the row headers to obtain the Quick Menu and then click Insert. Option 2: In the Ribbon, select Home > Cells > Insert > Insert Sheet Columns. Option 3: To use a keyboard shortcut, press CTRL + +. Three additional columns are quickly inserted into your worksheet all at once.