Office Settings & Configuration

How to Fix Excel Worksheet Jumping to a Different Row When Switching Sheets

Phi Hung VoPhi Hung Vo Nov 4, 2026 871 views

Question details

The user experiences an issue where navigating back to a specific worksheet causes the view to unexpectedly jump to a distant row near the end of the data.

How to Fix Excel Worksheet Jumping to a Different Row When Switching Sheets
Product
Microsoft Excel
Device & OS
not provided
Scenario
Switching between worksheets within a single macro-enabled workbook.
Observed behavior
The worksheet fails to retain the previously selected view and automatically scrolls down to a different row at the bottom of the dataset upon activation.
Before you start

Verify if 'Freeze Panes' is currently active on the problematic sheet, as conflicting view settings often cause scroll position errors during sheet navigation.

Solution 1Recommended

Save as XLSX Format and Update Microsoft 365

Converting the macro-enabled file to a standard XLSX format helps rule out structural glitches caused by corrupted macros. Updating Office ensures known display bugs are patched.

Even if macros are manually disabled, background file structure issues tied to the .xlsm format can persist. Saving the file as a standard workbook strips away potentially problematic embedded code.

1
Save the Workbook as XLSX

Open the affected workbook in Excel. Click on 'File' > 'Save As', choose your destination folder, and change the 'Save as type' dropdown to 'Excel Workbook (*.xlsx)'.

2
Check for Office Updates

Go to 'File' > 'Account' (or 'Office Account'). Under 'Product Information', click on 'Update Options' and select 'Update Now'.

3
Test the New File

Close Excel entirely, reopen the newly created .xlsx file, and test switching between the worksheets to see if the view remains stable.

Save as XLSX Format and Update Microsoft 365
Keep Original Backup: Keep your original .xlsm file as a backup in case you need to reference your original macro code later.
Free Microsoft Office alternative

Try WPS Office for a Bug-Free Spreadsheet Experience

If Microsoft Excel continues to experience view-jumping glitches or macro-related bugs, consider switching to WPS Office. It provides a highly compatible, lightweight alternative for managing complex workbooks seamlessly.

  1. 1. Download and Install: Visit the official WPS website and download the free WPS Office suite for your operating system.
  2. 2. Open Your Workbook: Launch WPS Spreadsheet and open your existing .xlsx or macro-enabled .xlsm workbook directly.
  3. 3. Navigate Smoothly: Switch between your worksheets seamlessly without encountering unexpected row jumps or saved view errors.
Fully compatible with Microsoft Excel file formats (.xlsx, .xls, .xlsm, .csv).Lightweight architecture ensures stable scrolling and fast worksheet switching.Familiar user interface requires no learning curve to master.Free to use for all essential spreadsheet management and data analysis tasks.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel sheet automatically scroll to the bottom when I click on it?

This usually happens due to background VBA event macros (like Worksheet_Activate) forcing a specific cell selection, conflicting 'Freeze Panes' settings, or a known bug in an outdated version of Microsoft 365.

Does simply disabling macros fix the worksheet jumping issue?

Not always. While disabling macros prevents the code from executing, structural file glitches tied to the macro-enabled format (.xlsm) can sometimes persist. Saving the file as a standard .xlsx format is the best way to completely strip away these issues.

How do I remove a custom view that might be forcing a row jump?

Go to the 'View' tab on the Excel ribbon, click on 'Custom Views' in the Workbook Views group, select any view that might be causing the problem from the list, and click the 'Delete' button.