How to view two sheets side by side

Uploaded time: March 29, 2022 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

Free Download
Free download

How to view two sheets side by side

How to view two sheets side by side

When checking data in WPS Spreadsheet, we frequently need to check and edit multiple sheets at the same time. We'll learn how to see two pages on the same screen today.

· Step one: Create and view two sheets side by side

First, let's open an Excel file containing multiple worksheets. Click New window in the View tab. At this time, another identical Excel document window will appear. These two windows are  presenting the same file. No matter which one is edited, the changes can be found on both sides.


· Step two: Arrange the windows

Click Arrange all in the View tab to pop up a dialog, where you can choose one arrangement method as needed. We can select Horizontal Text Box, Vertical Text Box, or Cascade. After selecting, you can view two sheets side by side.

To return to the normal view mode, click the Maximize button in the upper right corner of the workbook.


This is all about viewing two sheets side by side. Did you get it?

WPS Spreadsheet is a powerful chart and form processor. In WPS Academy, you can learn not only how to use Spreadsheet to sort out data but also how to corporate numeric information into graphs. By watching the step-by-step tutorials on WPS Academy, you will become a spreadsheet expert soon.