Adding a row using the insert row
- Type a value in one of the cells of the insert row to quickly add data. This will automaically add the row to the end of the list and specify the next row as the insert row.
Adding a row or column using auto-expansion
- If you type in a empty row or column that is adjacent to the list, the list will automatically expand to integrate the row or column into the list.
Notes
- You can turn off auto-expansion by unchecking the Include new rows and columns in list option on the AutoFormat As You Type tab of the AutoCorrect dialog box. This dialog box can be displayed by clicking AutoCorrect Options on the Tools menu.
- The list will not automatically expand if you type in a row below the list if you have the total row displayed.