Adding Rows and Columns to Workbooks

<< Click to display table of contents >>

Adding Rows and Columns to Workbooks

Location: Edit Template

Adding a new row to the workbook

1.Click where you want to add a new row. The row will be added above the selected row.

Note! If you add a row to a part of a sheet where conditional formatting is applied, the existing block of conditionally formatted rows will be broken into two separate conditionally formatted blocks. The intended functionality of formatting may be lost.

Tip! If you want to add more than one row, select the number of rows you want to add on the template. The same number of new rows will be added.

2.Click insert-row32x32 Rows and select Add row(s) from the drop-down list (alternative: click the row with the right mouse button and select Add row(s) from the popup menu).

Adding a new column to the workbook

1.Click where you want to add a new column. The column will be added to the left of the selected column.

Tip! If you want to add more than one column, select the number of columns you want to add on the template. The same number of new columns will be added.

2.Click add-column Columns and select Add column(s) from the drop-down list (alternative: click the column with the right mouse button and select Add column(s) from the popup menu).

Deleting rows or columns

1.Select the rows or columns you want to delete.

2.Click insert-row32x32 Rows or add-column Columns and select Delete row(s) or Delete column(s) from the drop-down list (alternative: click the row or column with the right mouse button and select Delete row(s) or Delete column(s) from the popup menu).