Freeze buttons?

  • Thread starter Thread starter Anil K
  • Start date Start date
A

Anil K

Is there a way to make buttons (I created these with the
Forms toolbar) in Excel not to be influenced by vertical
and horizontal scroll bars?

I have created a list of buttons on my spreadsheet that I
would like to "dock" at a particular location on the sheet
so I can access them while scrolling up, down or
horizontally in the sheet. The problem I have is when I
scroll down, the buttons disappear since they are attached
to cells. I have about a 1000 rows, so it is hard to
scroll up again to access these buttons.

Any help would be appreciated. Thanks in advance.
 
You can't freeze buttons, but you can freeze panes below & to the right so
the buttons will always show. Select a row below your buttons, then use
Window/Freeze Panes

Bob Umlas
Excel MVP
 
You must log in or register to reply here.

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

Similar Threads

horizontal scroll bar 1
Protect selected settings in 'options' 4
How do I lock a section of cells in place 1
Excel Date Setting 1
Inexperienced Use Need Help 3
How to freeze one column vertically, one horizontal in same sprdsh 4
Can't access memory stick 6
hiding freeze pane reference lines 3

Back
Top