See all How-To Articles

How to Create a Floating Table in Excel

This tutorial demonstrates how to create a floating table, one that can move with you, in Excel.

 

floating table intro

 

Creating a Floating Table

To create a floating table in Excel, use the Camera Tool. This tool allows the user to capture an image of a dataset – be it a range of cells, a chart, or a table. Once this image is captured, it can be moved around your worksheet like any other Picture. The advantage is however, that it is linked to the original source data and should that source data change, then your image is updated to reflect the changes.

  1. First, make the Camera accessible by adding it to the quick access toolbar. You can see how to do this by clicking here.
  2. Highlight the table that you wish to create a floating table from, and then on the toolbar, click the Camera icon.

 

floating table camera

 

  1. Click where you wish the floating table to be placed. it’s automatically inserted into your worksheet at this location.
  2. Now, change some values in your original table. Notice that your floating table automatically gets updated.

 

floating table data change

 

More on tables…

See all How-To Articles