Scroll bar Scrolls the cells that are supposed to be fixed

New Contributor


I am designing a calendar as a vacation tracker for my company. I added a Scrollbar to it so, scrolling is done more easily. Employees are only supposed to type “V” for vacation and “F” for flexible day leave under the desired dates. The problem is that when I type V or F if I scroll using my Scrollbar, the V and F will move within the calendar. So, we won’t be able to know exactly which days our employees were on V or F. I truly appreciate your help. 

I am using Win10, Excel 365 on my System.

2 Replies


The scrollbar changes the dates in H8:NH8. This is not desirable. So I'd remove the scrollbar, and let users use the built-in scrollbar at the bottom of the sheet.