How to Create Scrolling Tables in Google Sheets?

How to Create Scrolling Tables in Google Sheets?
Reading Time: 2 minutes

Learn to create a scrolling table of data range to use filters without changing the data range.

Background

There can be trouble in visualizing graphs alongside a large dataset as scrolling down would disappear the chart. In order to view the graph and dataset side by side, you can create Scrolling Tables in Google Sheets on the dataset. Scrolling Tables will help you navigate up/down the dataset without actually going down the screen.

Scrolling Table for the Chart
Figure 1: Scrolling Table for the Chart on the right. 

Steps to Create Scrolling Tables in Google Sheets

Step 1: Selection of Data Range

  • Select the dataset.
  • Left-click on cell A1 and drag it down to D18 along with the titles of the variable columns as shown below:
Selection of Data Range
Figure 2: Selection of Data Range

Step 2: Insert Chart for Data Range

  • After selecting the cells, click on the Insert tab from the navigation bar and select the Chart option to create a chart for the data range.
Select Chart for the data range
Figure 3: Select Chart for the data range

Step 3: Select Table Chart

  • After selecting Chart, click on Chart Type.
  • Scroll down to Other Charts.
  • Select Table Chart as shown below.
Select Table chart to create a Scrolling Table for the data range
Figure 4: Select Table chart to create a table for the data range

Scrolling Table of Selected Data Range
Figure 5: Scrolling Table of Selected Data Range

Step 4: Sort Data

  • Once the Table is created, you can sort data without sorting them on the original data range.
  • Select on Salary, and you can sort them Ascending or Descending without disturbing the original data range.
  • Similarly, you can do this for all other columns
Scrolling table for sorting data without disturbing the data range
Figure 6: You can use the scrolling table for sorting data without disturbing the data range | Create Scrolling Tables in Google Sheets

See Also

Google Sheets: How to Use Pivot Tables : Learning how to create and use Pivot Tables for analysing data in Google Sheets.