Excel 2016 Tips and Tricks

Excel 2016

Lesson 2 – Working with Tables

Steps

Practice Data

7. To hide or redisplay the header row, deselect or select the Header Row option in the Table Style Options group. The Header Row is hidden or displayed accordingly.

Click

to

deselect it

Practice the Concept: Redisplay the Header Row , turn off emphasized formatting for the First Column and Last Column and display Banded Rows instead of Banded Columns .

C REATING A T OTAL R OW  D ISCUSSION A total row is a special calculation row you can add to the bottom of an Excel table to calculate column results.

By default, when you add a total row to a table, Excel adds the word Total below the first column and automatically adds a calculation to the last column. If the last column contains numeric entries, it sums the entries. If the last column contains text or date entries, it counts the number of entries.

You can create a calculation for any column in your table. When you select any cell in the total row, a drop-down arrow appears to the right of the cell providing access to a list of commonly used functions. The functions listed are Average , Count , Count Numbers , Max , Min , Sum , StdDev , and Var . You can select any of these functions for each column or remove a calculation by selecting None from the list. You can change which function is applied to a column at any time by redisplaying the list of functions.

You can turn off the total row at any time. When you turn it back on, Excel remembers which calculations were used for each column.

OFFICEPRO, Inc.

Page 29