Floating table

[Niall 84]

Does anyone know if it is possible (preferably without using Macros)
to have a table that always stays at the top of the screen?

Basically when I scroll down along the information I lose the table,
but I cant use a standard frame freeze as then the information becomes
very difficult to make out!!!

Maybe this can be done by manipulating the frame freeze somehow or
maybe there is some other way of doing it.

If anyone has any ideas please let me know.

Thanks,

Niall.

 

[Pete_UK]

If the table is too big for Freeze Panes, then I'm not sure how making
it "floating" will help. You can split the window and have two views
of the same sheet, so that might be something to look into. You can
also have other windows looking at the same sheet, so you might like
to try that (Window | New Window and then adjust the sizes and zoom
levels etc).

Hope this helps.

Pete

 

[Max]

Thinking about a floating "legend"? An alternative play using data
validation which might appeal to you ..

Select say, col B

Click Data > Validation > Input Message tab
Enter the title, and the input message, eg:

Title: Legend
Input message:
Ratings
---------
AAA = Triple A
AA = Double A
etc

Click OK

Select any cell in col B, and the "legend" box will be visible. Move the box
to a desired display position. Now when you scroll up / down, the "legend"
will continue to be visible in the same position (as long as the active cell
remains within col B)

 

[Niall 84]

Thank you both for your help,

I will get working on the solution!!!

Thanks,

Niall.

 

[Max]

Welcome