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