Excel 2016 Tips and Tricks

Excel 2016

Lesson 2 – Working with Tables

C HANGING THE T ABLE S TYLE  D ISCUSSION You can change the Table Style at any time. The Table Styles gallery provides a wide variety of styles to enhance the appearance and readability of your data. The Table Styles group in the Design tab displays a Quick Styles gallery of table styles. You can select one of the four displayed styles by clicking on the desired style. You can use the scroll arrows to the right of the Quick Styles gallery to display additional styles four at a time or you can select the More button below the scroll arrows to open the Table Styles gallery to view all the available styles.

As you move the mouse over a style in either the Quick Styles gallery or the Table Styles gallery, the style is previewed on the selected table.

The Table Styles gallery

NOTE Although Excel applies a Table Style to the data when you define a range as a table, you can remove the Table Style, if desired. Click the More button in the Quick Styles gallery and select Clear from the menu below the Table Styles gallery.

OFFICEPRO, Inc.

Page 25