Home > Topics > excel > How to use multiple tabs in one excel window

How to use multiple tabs in one excel window

Release: 2019-06-15 13:55:46
Original
28217 people have browsed it

How to use multiple tabs in one excel window

Through the settings that come with OFFICE excel, you can try to display two or more tables in one window, mainly for data comparison or window switching. Multiple tags can be implemented using extension plug-ins. WPS forms come with this function, and multiple workbooks are displayed in one window.

The specific operation steps are as follows:

1. The WPS form comes with this function. Multiple workbooks are displayed in one window, as follows:

How to use multiple tabs in one excel window

2. Through the settings that come with OFFICE excel, you can try to display two or more tables in one window, mainly for data comparison or window switching. As follows:

Open EXCEL, click [View] - [Switch Window], you can switch between multiple documents, as shown in the figure.

How to use multiple tabs in one excel window

1. You can click [View Side by Side] to pop up a table for selecting side by side comparison. You can compare two tables

How to use multiple tabs in one excel window

# #2. In any worksheet, operate "View - Rearrange All - Vertically Side by Side" to display the workbook in one window

How to use multiple tabs in one excel window

3. Click [File] - [Options] - [Advanced] - [Display], find this item, if checked, you can view the thumbnails of the document in the taskbar; if unchecked, you cannot preview multiple documents.

How to use multiple tabs in one excel window

##三

、Office Tab Enterprise is an extension plug-in of the office multi-tab tool (Office Tab Enterprise). The main function of Office Tab is to Let office 2013, office 2010, 2007, and 2003 realize multi-window tabbed browsing. For more Excel-related technical articles, please visit the

Excel Basic Tutorial

column!

The above is the detailed content of How to use multiple tabs in one excel window. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template