A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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:
- Ensure Excel is up to date
- Go to File > Account > Update Options > Update Now.
- 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.
- Hold Ctrl while opening Excel or run
- Disable unnecessary add-ins
- Go to File > Options > Add-ins > Manage COM Add-ins > Go, uncheck any non-essential add-ins, and restart Excel.
- Add-ins can interfere with rendering and scrolling performance.
- Go to File > Options > Add-ins > Manage COM Add-ins > Go, uncheck any non-essential add-ins, and restart Excel.
- 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.
- Adjust display settings
- High DPI or scaling can affect rendering.
- Right-click the desktop > Display settings > set Scale to 100% and test again.
- 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.