1
Choose where to add a row
Start by selecting the row where you want to insert a new row.
In this example, a new row is added below the Salary / Wages row.
Adding Rows and Columns to a Spreadsheet Block
Easily import .xlsx files into a Spreadsheet Block to save time when creating and editing data in your documents.
Adding Rows and Columns
- Insert additional rows into your spreadsheet.
- Add new columns for more detailed data entry.
Add rows and columns to a spreadsheet
2
Open the Insert menu
Go to Insert in the toolbar.
This menu contains options for adding rows and columns.
3
Add a row below
Under Rows, choose Add Row Below.
A new row will be inserted underneath the selected row.
4
Enter data in the new row
Enter your new data in the added row.
The spreadsheet now has more space for additional information.
5
Choose where to add a column
To include a new column, select the column beside where the new one should appear.
In this example, a Total column is added to the right.
6
Add a column right
Return to Insert, select Columns, and choose Add Column Right.
A new column will be inserted to the right of the selected column.
7
Review the new column
Your spreadsheet now has a new column ready for input.
Enter the column heading and any values you need.
FAQs