Saturday, April 13, 2013

Insert a Table vs. Range of data

It is best to use a table for several reasons

•Easier to reference
•Easy to add to without having to adjust formula ranges or pivot tables
•Easier to view data because of the auto alternating line colors
•Any formulas added will auto fill to the end of the column

To Convert a range to a Table

•Select Insert Ribbon
•Click the Table Button
•Select your Range if it didn’t do it automatically

No comments:

Post a Comment