Tables offer special features for working with data.
There are several ways you’re able to add and remove rows.
With any cell selected in the table, Insert will add a new row above.
And, the Delete button will delete rows.
Sometimes these buttons don’t do exactly what you want.
In that case, it’s possible for you to use the more specific table commands in the menu.
you’re able to access these same commands with the Right-Click menu.
Notice that all of these operations work when more than one cell is selected.
To add new data rows to the end of a table, use the Tab key.
At the end of the last row, Tab will insert a new row below.
Another way to add rows to a table is to paste data below the table.
The table will automatically expand to include the pasted rows.
Notice if I delete just the data from a table, therangedoesn’t change.
I need to use the drag handle manually as a second step.
Normally, it makes more sense to delete entire rows from the start.
The support for drag and drop in tables makes them convenient for restructuring data.
With an entire row or column selected, you’re free to just drag to a new location.
Then, hover the cursor over the edge of the selection until you see a 4-headed arrow.
Then you’re free to drag the row to a new location.
The steps are the same for columns, but you’ll need to click twice to choose the header.
The right-click menu also has commands to select table rows and columns.
Finally, you’re free to use special keyboard shortcuts to select rows and columns as well.
Use Control + Space to select a column.
Use Shift + Space to select a row.
All of these methods all work with multiple rows and columns as well.
