Floating

W

werdna

I have frozen the panes of a sheet already.
The column headings are frozen at the top and the client data to the
left.

[SIDE WITH CLIENT HEADINGS] --- [OTHER HEADINGS]
--------------------------------------------------------------------
[CLIENT DATA - SCROLL DOWN] --- [OTHER DATA - SCROLL DOWN AND ALONG]

Get it?

Well, I have add a few rows above the headings for data I want to stay
there. So, if I place it above the client headings - it stays because
that cant be moved. But if I place anything about the other headings,
it is lost when you scroll right.

Is there a way for me to add like floating layer thing above the client
headings - so even though the data can be scrolled, that just floats and
dont move?


--- denotes a line of frozen pane. ;)
 
D

Dave Peterson

See on response in .excel.

I have frozen the panes of a sheet already.
The column headings are frozen at the top and the client data to the
left.

[SIDE WITH CLIENT HEADINGS] --- [OTHER HEADINGS]
--------------------------------------------------------------------
[CLIENT DATA - SCROLL DOWN] --- [OTHER DATA - SCROLL DOWN AND ALONG]

Get it?

Well, I have add a few rows above the headings for data I want to stay
there. So, if I place it above the client headings - it stays because
that cant be moved. But if I place anything about the other headings,
it is lost when you scroll right.

Is there a way for me to add like floating layer thing above the client
headings - so even though the data can be scrolled, that just floats and
dont move?

--- denotes a line of frozen pane. ;)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top