Microsoft Office Tutorials and References
In Depth Information
Adding new rows or columns
To select an entire row: Move the mouse to the left of a cell in the fi rst column,
and the mouse pointer changes to a right-pointing arrow. Click to select the entire
table row. You can also press Shift+Spacebar to select a table row.
To select the entire table: Move the mouse to the upper-left part of the
upperleft cell. When the mouse pointer turns into a diagonal arrow, click to select the
data area of the table. Click a second time to select the entire table (including the
Header Row and the Total Row). You can also press Ctrl+A (once or twice) to select
the entire table.
Right-clicking a cell in a table displays several selection options in the shortcut menu.
Adding new rows or columns
To add a new column to the end of a table, select a cell in the column to the right of the
table and start entering the data. Excel automatically extends the table horizontally and
adds a generic column name for the new column. Similarly, if you enter data in the row
below a table, Excel extends the table vertically to include the new row.
An exception to automatically extending tables is when the table is displaying a Total Row. If you enter data below the
Total Row, the table won’t be extended and the data won’t be part of the table.
To add rows or columns within the table, right-click and choose Insert from the shortcut
menu. The Insert shortcut menu command displays additional menu items:
Table Columns to the Left
Table Columns to the Right
19
Table Rows Above
Table Rows Below
When the cell pointer is in the bottom-right cell of a table, pressing Tab inserts a new row at the bottom of the table,
above the Total Row (if the table has one).
When you move your mouse to the resize handle at the bottom-right cell of a table, the
mouse pointer turns into a diagonal line with two arrowheads. Drag down to add more rows
to the table. Drag to the right to add more columns.
Search JabSto ::




Custom Search