Forum Discussion

Reception305's avatar
Reception305
Copper Contributor
Nov 26, 2024

Freeze Panes Question

Hello Excel Experts,

I have a problem that I'm facing that maybe you all might be able to solve.

I'm trying to freeze my top and side navigation bar in place in Excel. Technically I got the top

bar to work, it stays in place when I scroll vertically and technically side bar is also frozen in place

but only when scrolling horizontally. Anything below the top navigation bar when scrolling vertically

moves.

Is there a way to freeze both the top and side columns in place so my navigation buttons are always available to use without using VBA? 

I have tried the split window option, it works but there's the duplicate view of what was split which if there was a way to hide/lock that duplicate image behind the stationary split view.

I also tried combining split view window with the Freeze pane option but that didn't really work

I do have a video of what I am talking about with the freeze pane issue option that I'm having which I have attached, along with the file as well

 

Thank you, and I look forward to the help!!!!!

excel
Formulas and Functions
Macros and VBA

2 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Nov 26, 2024

    To do what you want, you'd have to move all items you want on permanent display to the top left corner, but that will become crowded:

     

    • Reception305's avatar
      Reception305
      Copper Contributor
      Dec 04, 2024

      Hmmmm.... I don't quite get why the vendor and category slicers had to move to the corner along with others, especially since the top section is frozen in place. From what your saying I would just need to move my inventory/order sheet buttons up in the frozen area at the top since there is no clear work around for the side column to be frozen in place while vertically scrolling unless I want to use a VBA macro to make my buttons move while scrolling.

      Well, I kind of figured that would be the response from the research I gathered. So, I ended up moving the inventory/order sheet buttons from the side of the worksheet to the top. I modified them so they look more button like and made them dynamic so that when they are selected the button is highlighted and prominent on the screen. Although I couldn't get the navigation sidebar to be stationary. I thought this was a good work around.

      Thank you for your help

Resources