With Spreadsheet.com, you can quickly add new empty columns to your worksheets. Insert columns to add new data, or cut and paste existing columns. Or you can move columns to rearrange existing data.
Topics in this Article
- How to Insert a New Empty Column
- How to Insert Multiple New Empty Columns
- Column Styling and Inserted Formulas
- How to Move Columns
- How to Insert Copy or Cut Columns
How to Insert a New Empty Column
You can either insert a column by selecting the whole column or a cell in the column. Once you've selected the column or cell next to where you want your new column, then right-click on the column or click the column header, and select Insert column right/left from the menu options.
You can also insert a column via the Insert Menu:
When you insert a new column, an Add a column dialog box opens. Here, you can specify the column name and data type. If left unspecified, the column name remains blank, and the data type is set to the Automatic data type.
Click Add to insert a new column.
How to Insert Multiple New Empty Columns
Similar to inserting one additional column and deleting multiple columns, Spreadsheet.com allows you to insert multiple columns at the same time.
Begin by selecting multiple columns on either side of the space where you intend to insert new columns. Then, either right click on one of the selected column headers, or select the column dropdown on one of the selected columns, and select “Insert # columns right” or “Insert # columns left” from the menu. You can insert as many columns as you have selected.
Column Styling and Inserted Formulas
New columns adopt the cell styling (but not the data type) of the column you selected when you initiated the column insert. For instance, in our animation our "Primary Contact" has the same formatting as the "Revenue" Column, as evidenced by the similar formatting of the column header:
Any formulas are automatically readjusted to follow the inserted column. For instance, our "Revenue" column contains formulas that adjust to account for a new column. For complete details, see Formula readjustment.
How to Move Columns
In Spreadsheet.com, it's easy to move columns around by dragging and dropping them. To move a column (or multiple columns) simply grab the column or columns you would like to move, hold down your left click and drag them to the new location in the worksheet.
Alternatively, you can move columns using the Move Column option in the Edit menu.
Simply select the desired column, then click Edit and either Move column left or Move column right.
How to Insert, Copy, or Cut Columns
In Spreadsheet.com, the best way to insert a column is to move it. You can easily move columns without having to copy and paste at all. But if you'd prefer to copy and paste columns, you can insert a new column and then paste in the column you want to move.
To copy or cut data from other worksheets, see our article on copying and pasting data.