How to Insert Floating Table in Excel (2 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

Floating table is a useful tool in Excel worksheets. For data analysis and other practical purposes, we may need to insert this table. In this article, we will show you how you can insert floating tables using in-built Excel features.

Download Practice Workbook

You can download and practice this workbook.

2 Ways to Insert Floating Table in Excel

We are going to create floating windows using simple Excel features. First, we will use the Watch Window feature, and then we will Insert movable table. So, let’s start these procedures.

1. Use of Watch Window Feature

We have taken a dataset of different fruits and their respective selling information.

At the bottom, there are two cells which give the total amount of Order and Sale.

We will add these two cells to the watch Window box.

 How to Insert Floating Table in Excel


➤ Go to Formula > Formula Auditing and click on Watch Window.

A Watch Window will open.

 Floating Table in Excel

➤ Now, select the cell you want to see in the Watch Window. We selected C11.

➤ Then, click on Add Watch.

➤ In this new window, click on Add.

Thus, all the information about C11 including value, formula, etc. will be shown in the first row.

Let’s select another cell. We want to know the total amount of Sales.

➤ So select E11.

➤ Then, click on Add Watch.

 Floating Table in Excel

➤ And finally, click on Add in the new window.

Thereby, we get these two cells’ information in the floating table.

This window floats when you scroll in the Excel workbook.

And, this window shows up on every sheet of a workbook.

Read More: How to Add Floating Comment in Excel (3 Simple Methods)

2. Floating Table from Insert Option

We can insert data tables in Excel. And this table is movable. Let’s see the procedure.


 Floating Table in Excel

➤ First, select the data table(B4:E11).

➤ Then select the Table option from the Insert ribbon.

So, the Create Table window will open. You can see the data range in the box.

➤ Now, press OK.

 Floating Table in Excel

So, the dataset has been set in a table. You can change the color and format as you want.

Now we will move this table.

➤ Select any cell within the table and move the mouse cursor at any edge of the table. The cursor will indicate the direction to all four sides.

➤ Now, press the right button of the mouse and Drag the cursor to your desired location.

➤ And, select Move Here.

 Floating Table in Excel

Thereby, the table will move to a new position.

Read More: How to Create Floating Cells in Excel (2 Easy Methods)


Thank you for making it this far. We hope, now you can easily insert floating table in excel. If there are any queries or suggestions regarding any of these procedures, feel free to leave them in the comment section.

Related Articles

Sourav Kundu

Sourav Kundu

Bio: Hi, I am Sourav Kundu. I live in Adabor, Dhaka. I graduated in Naval Architecture and Marine Engineering from BUET. I am really excited to be a part of SOFTEKO family. I want to develop my research skill and find innovative solutions for the given problems.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF