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. Here are the steps:

Background

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

Data set to create scrolling tables in Google Sheets

You can make a copy of the spreadsheet containing the data and the table.

Copy the spreadsheet

Steps to Create Scrolling Tables in Google Sheets

Step 1: Select the data range

Select the entire range of data along with the headers to create a scrolling table in Google Sheets.

Selecting the data range to create a scrolling table in Google Sheets

Step 2: Insert chart for the selected data

After selecting the cells, click on the Insert tab from the navigation bar and select Chart.

Inserting chart to add a scrolling table in Google Sheets

Step 3: Select Table Chart

  • After selecting Chart, click on Chart Type.
  • Scroll down to Other Charts section.
  • Select Table Chart as shown below.
Selecting the chart type to insert a scrolling table in Google Sheets

‍The default chart will be changed to a scrolling table.

The scrolling table in Google Sheets

Step 4: Sort Data

  • Once the table is created, you can sort data in the table without affecting the original data range.
  • Select Current Price to sort by price, and you can sort them in ascending or descending order without altering the original data range.
  • Similarly, you can do this for all other columns.
Sorting the column of scrolling table in Google Sheets

See Also

Some similar articles you may find useful.

https://blog.tryamigo.com/sort-pie-charts-by-percentage-in-google-sheets/

https://blog.tryamigo.com/how-to-create-a-funnel-chart-in-google-sheets/

https://blog.tryamigo.com/what-are-slicers-in-google-sheets/

X
Hire expert data analysts on-demand. Get 30 Days Free Trial