Select the data table that you want to keep visible, then click Copy > Copy as Picture under the Home tab, see screenshot:Ģ. There is no direct way for you to insert the floating table, so you need to convert the table data to an image, and then apply a code to finish it, please do as this:ġ. Insert floating textbox in Excel with VBA code Insert floating table in Excel with VBA code This may be an interesting task, this article, I will introduce a quick trick to solve it.
If you have a table or a textbox with some important data which you want to always be visible on the worksheet screen even though when you scroll up or down the worksheet. How to insert floating table or textbox in Excel worksheet?
