Microsoft Office Tutorials and References
In Depth Information
Working with Tables
Timesaver
Enter a formula in the row directly below a table without a total row to
create a total row without the word Total.
Did You Know?
You can create a calculated column. A calculated column uses a single
formula that adjusts for each row in a table. To create a calculated
column, click a cell in a blank table column, and then type a formula.
The formula is automatically filled into all cells of the column. Not
every cell in a calculated column needs to be the same. You can enter a
different formula or data to create an exception.
Working with Tables
After you create a table, you can sort the entries, add new entries, and display totals. You
can insert rows anywhere in a table or add rows at the bottom of the table. To add a blank
row at the end of the table, select any cell in the last row of the table, and then press Enter,
or press Tab in the last cell of the last row. If you no longer need the data in table form,
you can convert the list back to normal Excel data. Selecting table rows and columns is
different than selecting worksheet rows and columns. Selecting cells is the same.
Insert a Row or Column
Click a cell in the table where you want to insert a row or column. To insert
multiple rows or columns, select more than one row or column.
Click the Home tab.
Click the Insert button arrow, and then do one of the following:
Rows. Click Insert Table Rows Above or Insert Table Rows Below .
Columns. Click Insert Table Columns to the Left or Insert Table
Columns to the Right .
Search JabSto ::




Custom Search