[Fix:] Excel View Side by Side Not Working

Sometimes, users encounter identical Excel files or want to compare between files. In that case, Excel View Side by Side is very useful. However, in some instances, users come across Excel view side by side not working issue. Opened single window, Non-responsive View Side by Side mainly result in Excel View Side by Side not working issue.

Dataset-Excel View Side by Side Not Working

In this article, we demonstrate multiple tricks that resolve the Excel View Side by Side not working issue.


Download Excel Workbook

Practice with the below workbook:


3 Easy Resolves for Excel View Side by Side Not Working Issue

Excel offers side by side view for Worksheets or Workbooks of the same or different Workbooks. By going View > Select View Side by Side (in the Window section), users can view multiple files in preferred arrangements (i.e., Tiled, Horizontal, Vertical, or Cascade). But on occasions, users face Excel View Side by Side is not working. The reasons behind this issue can be the outcome of the following 3 incidents:

Reason 1: Only 1 window is opened in Excel (Caused View Side by Side Greyed Out).

Reason 2: The Arrangement of windows (Caused Non-responsive View Side by Side).

Reason 3: Already opened side-by-side windows (Caused View Side by Side and Reset Window Position not working).

We demonstrate the way-outs to resolve the above reasons in the latter section.


Issue 1: View Side by Side Is Greyed Out

๐Ÿ”„ Letโ€™s assume you want to compare two identical files using Excel View Side by Side feature. So, you go through View > View Side by Side (in the Window section. But surprisingly you see the View Side by Side feature is greyed out.

Gray Out-Excel View Side by Side Not Working

๐Ÿ”บ The reason behind this Gray Out View Side by Side feature is you only have one Excel window or workbook opened in Excel. Use View > New Window (from the Window section) to open another window of the same workbook or different.

New Window

๐Ÿ”ผ After opening the New Window, you see Excel displays the window number following the file name as depicted in the below screenshot.

New Window

๐Ÿ”ผ Now, if you check the current status of the View Side by Side feature in the View tab, you see the greyed-out shade has been removed as shown in the below picture. You are good to perform View Side by Side feature for two or more windows.

View Side by Side enabled

Read More: How to Open Two Excel Files Separately (5 Easy Methods)


Issue 2: Non-Responsive Excel View Side by Side

๐Ÿ”บ In cases, you previously executed the View Side by Side feature but now it is not responding. Go to View > Click on Reset Window Position (from the Window section). After that, Excel resets all the window arrangements, and you can choose one of your desired window position to view multiple windows side by side.

Reset Window Position-Excel View Side by Side Not Working

Read More: How to Enable Side-by-Side View with Vertical Alignments in Excel


Similar Readings


Issue 3: Nothing Happens after Executing All Possible Way-Outs

๐Ÿ”„ While working with huge datasets there are incidents of opened files or windows not working for the View Side by Side feature. In those cases, you have to reopen new windows and execute the Excel View Side by Side feature.

๐Ÿ”บ After closing all the windows,

โžง Open your 1st Excel workbook manually or use Excel File > Open.

โžง Staying on the opened workbook, Press CTRL+N or use Excel File > Open to open a new workbook or Excel file from your device directory.

Keyboard shortcuts-Excel View Side by Side Not Working

๐Ÿ”ผ Afterward, execute View > View Side by Side as directed in the following image. And you see the View Side by Side option is enabled.

Enabled

Read More: How to View Excel Sheets in Separate Windows (4 Methods)


Conclusion

In this article, we discuss and resolve Excel View Side by Side not working issue. We identify the reasons behind this issue occurring and provide solutions for each of them. Hope you find your desired solution regarding this issue. Comment, if you have further inquiries or have anything to add.


Related Articles

Maruf Islam

Maruf Islam

My self, Maruf Islam, an engineer and Excel & VBA Content developer on Exceldemy. I enjoy solving problems, finding workable solutions, and most of the part I really like to take on challenges. On Exceldemy I write articles discussing various way outs of Microsoft Excel's stuck ons.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo