ExcelbyJoe – Learn Excel Dashboards and Functions

Learn to use Spreadsheets more effectively

Create Scrolling Table of Data in Excel – View hundreds of records in 1 spot

Sometimes you have a small space in Excel to display your data.  However you may have a lot of records to show.  Instead of building this long table or putting them to a chart, you can create a table with a scroll bar.  This way you can scroll through hundreds of records in one spot in your spreadsheet.

I take you through getting the data to building the pivot table to setting up the scroll bar to make the table appear moving.

Download the sample file here to follow along: http://bit.ly/excelbyjoe_downloads