# 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 built-in Excel features.

## Insert Floating Table in Excel: 2 Ways

We are going to create floating windows using simple Excel features. First, we will use the Watch Window feature, and then we will Insert a 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 that give the total amount of Order and Sale.

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

Steps:

âž¤ Go to Formula > Formula Auditing and click on Watch Window.

A Watch Window will open.

âž¤ 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.

âž¤ 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.

### 2. Floating Table from Insert Option

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

Steps:

âž¤ 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.

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.

Therefore, the table will move to a new position.

Read More: Does TABLE Function Exist in Excel?

## Conclusion

Thank you for making it this far. We hope that 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

<< Go Back to Excel Table | Learn Excel

## What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Tags:

Sourav Kundu

Sourav Kundu, BSc, Naval Architecture & Marine Engineering, Bangladesh University of Engineering and Technology, is a dedicated technical content creator of the ExcelDemy project. He has a keen interest in Excel and he leverages his problem-solving skills to provide solutions on user interface with Excel. In his position as an Excel & VBA Content Developer at ExcelDemy, Sourav Kundu not only adeptly addresses challenging issues but also demonstrates enthusiasm and expertise in navigating complex situations. Apart from creating... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF