Got any Excel Questions? Free Excel Help.
Create an Excel Table From List
As regular Excel users know, Excel works best when data is laid out in a classic table format. When set-up like a table we can take advantage of Excels many features, like AutoFilter ,Pivot Tables and many more. Unfortunately we cannot always dictate the lay-out of data as it is beyond our control.
Change Data Lists Laid Laid-out Like Below:
To a Classic Table Format Like Below;
Download the Free Excel Add-in from Ozgrid
See also Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions.
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.