Share via

Facing issue with header loading on horizontal scroll

Sawant, Tejashri P 0 Reputation points
2025-09-30T05:09:57.04+00:00

I created an Excel file with macros, which is protected and has the header row (first row) locked. When users scroll horizontally, some header values do not display correctly and are not fully loaded. This issue only occurs in the Windows version of Excel; it works fine on Mac.

Microsoft 365 and Office | Excel | For business | Windows
0 comments No comments

2 answers

Sort by: Most helpful
  1. AlexDN 11,420 Reputation points Microsoft External Staff Moderator
    2025-09-30T06:19:00.8233333+00:00

    Hi @Sawant, Tejashri P
    Thank you for posting your question in the Microsoft Q&A forum.

    Based on your description, I understand that the header doesn’t display correctly while scrolling in Excel file with macros.

    To better assistance, could you kindly confirm following information:

    • Which Excel version are you using? (You can check under File > Account > About Excel.)
    • Does the issue still happen if you start Excel in Safe Mode? (Press Windows + R, type excel /safe, and open the file.)
    • Are there any macros in the file that turn ScreenUpdating off?

    In the meantime, I recommend some steps below:

    1. Ensure Excel is up to date
      • Go to File > Account > Update Options > Update Now.
    2. Test in Safe Mode
      • Hold Ctrl while opening Excel or run excel /safe.
      • If the issue disappears, an add-in or custom setting is likely the cause.
    3. Disable unnecessary add-ins
      • Go to File > Options > Add-ins > Manage COM Add-ins > Go, uncheck any non-essential add-ins, and restart Excel.
        Untitled
      • Add-ins can interfere with rendering and scrolling performance.
    4. Check macro settings
      • Since your file uses macros, ensure macros are enabled and not blocked by security settings.
      • If macros disable ScreenUpdating, make sure they turn it back on and refresh the screen after running.
    5. Adjust display settings
      • High DPI or scaling can affect rendering.
      • Right-click the desktop > Display settings > set Scale to 100% and test again.
    6. Locking headers
      • Unprotect the sheet, remove and reapply Freeze Top Row, then re-protect the sheet.
      • This refreshes how Excel handles locked rows.

    Please understand that our initial response does not always resolve the issue immediately. However, with your help and more detailed information, we can work together to find a solution.

    Your detailed response will help us diagnose and investigate the issue more efficiently. If I misunderstood what you’re looking for, feel free to let me know or share a screenshot. I’d be happy to help further! 

    Thank you for your cooperation. I'm looking forward for your reply.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

    undefined

    1 person found this answer helpful.

  2. AlexDN 11,420 Reputation points Microsoft External Staff Moderator
    2025-10-07T04:30:42.5933333+00:00

    Hi @Sawant, Tejashri P
    Thank you for sharing the additional details and for trying all the suggested steps so far. I truly appreciate the effort you’ve put in to troubleshoot this.
    From your observation that the issue only occurs when using the mouse scroll wheel (but works fine with the scrollbar or navigation arrows), it seems related to how Excel refreshes the display during wheel scrolling on Windows.

    Please try some steps below:

    1. Disable Smooth Scrolling in Windows
      • Go to Settings > Bluetooth & devices > Mouse (or Control Panel > Mouse).
      • Turn off any “smooth scrolling” or similar options and test again.
    2. Update or Change Mouse Driver
      • If you use third-party mouse software (e.g., Logitech, HP), update it or temporarily uninstall to test with the default Windows driver.
    3. Test with Another Mouse or Touchpad
      • This helps confirm if the issue is hardware-driver related.
    4. Repair Office Installation
      • Go to Control Panel > Programs > Microsoft 365 (Or something like Microsoft Office, Office or so on) > Modify > Quick Repair (or Online Repair if Quick Repair doesn’t help).

    Thank you for your cooperation. I'm looking forward for your reply.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 
    undefined


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.