Skip to content

Create a Portable Table in Google Sheets

In this article, I will show you how to create a portable table in Google Sheets.

Now by a portable table, I mean that you can create a table of your data that you can physically move around your worksheet and manipulate. You can also sort the data and scroll through the table, all without affecting the source data in any way.

If you want to learn how to create a table like this in Google Sheets, then keep on reading!

How to Create the Table

To create a portable table in Google Sheets, start by selecting all of the data. An easy way to do it is by selecting the top left cell of your data and using the keyboard shortcut CTRL + A.

With the data selected, go to Insert Chart.

Then, in the panel on the right, change the ‘chart type’ to Table Chart.

You now have a portable table you can move around your worksheet.

How To Manipulate the Chart

Once you have created the portable chart, you can move it around your worksheet simply by clicking and dragging it.

You can also sort the data simply by clicking on any of the table headers.

And the best part is that you can make all of these changes to the portable chart without altering or affecting the source data in any way.

How amazing is that?

This Post Has 2 Comments

  1. This is so cool! I didn’t even know this was an option! Do you know if this is also available in Excel? I’m really excited about learning this and using it!

    1. There isn’t an exact replica in Excel. However, you can use something called the Camera Tool to sort of replicate this functionality. I will do my best to write an article about it in the future.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top