Fix Excel for the Web Cannot Move Cells After Freezing Panes
Question details
The user needs to restore the ability to drag or move cells in Excel for the web after freezing rows or columns. The issue occurs across browsers and workbooks but not in the desktop version.
- Product
- Excel for the web
- Device & OS
- not provided
- Scenario
- A user has frozen rows or columns in Excel for the web and then tries to drag or move cells; the operation fails or behaves incorrectly.
- Observed behavior
- Cells cannot be dragged or moved correctly after panes are frozen. The same files work normally in desktop Excel, so the behavior is specific to Excel for the web.
Before troubleshooting, close other Office files and note which browser and extensions you are using. If possible, open the affected workbook in desktop Excel to confirm that the drag issue is specific to Excel for the web.
Clear Microsoft Edge Cache and Test Excel for the Web in Another Browser
Use this first to determine whether the frozen-pane drag issue is caused by cached browser data or is specific to Microsoft Edge.
Excel for the web runs in the browser, so stale cached data or browser-specific behavior can prevent cell drag operations after panes are frozen.
In Microsoft Edge, select the three-dot menu in the top-right corner, then choose Settings.
Go to Privacy, search, and services, select Choose what to clear under Clear browsing data, check Cached images and files, and select Clear now.
Open the same workbook in Google Chrome or Mozilla Firefox, go to the View tab, freeze panes if not already applied, and try dragging the cell by its border.
Disable Browser Extensions and Update the Browser and Office
Use this if the issue continues after clearing the cache, because extensions or outdated software can interfere with Excel for the web drag operations.
Convert Legacy .xls Workbooks to .xlsx and Reapply Freeze Panes
Use this if the workbook is still saved in the older .xls format, which can cause compatibility issues in Excel for the web.
Use WPS Spreadsheets to Freeze Panes and Move Cells Without the Excel for the Web Bug
WPS Office is a free, lightweight Microsoft Office alternative that handles freeze panes and drag-and-drop cell movement reliably in WPS Spreadsheets. It opens and saves Microsoft Excel files with full format compatibility, offers a familiar ribbon UI, and lets you switch from Excel for the web without losing productivity.
- 1. Download WPS Office: Go to the WPS Office download page and select Download WPS Office Free for your device.
- 2. Open the workbook in WPS Spreadsheets: Launch WPS Office, open WPS Spreadsheets, and use File > Open to load the workbook.
- 3. Freeze panes and move cells: Select the View tab, choose Freeze Panes, then drag cells by their border to move them.
Frequently Asked Questions
Why can't I drag cells in Excel for the web after freezing panes?
This can be caused by cached browser data, browser extensions, legacy .xls file format, or a bug in Excel for the web. Clear the browser cache, test another browser, disable extensions, and convert the file to .xlsx.
Will clearing Microsoft Edge cache delete my Excel files?
No. Clearing cached images and files removes temporary browser data only. Your Excel files remain safe in OneDrive, SharePoint, or on your device.
Does WPS Spreadsheets support freeze panes and cell dragging?
Yes. In WPS Spreadsheets you can freeze rows or columns from the View tab and drag cells by their border to move them, just like in desktop Excel.
How do I convert an .xls workbook to .xlsx?
Open the workbook in desktop Excel or WPS Spreadsheets, select File > Save As, and choose Excel Workbook (*.xlsx) as the saving format. You can also copy the data into a new .xlsx workbook.
Is Excel for the web the same as desktop Excel for freeze panes and dragging cells?
No. Excel for the web has more limited features and may behave differently in browsers. Desktop Excel and WPS Spreadsheets generally provide more reliable freeze pane and drag operations.
