WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches

        598 results for open 2 excel windows side by side office 2010

        • All Tutorials
        • Video Tutorials
        • Quick Tutorials
        • All
        • Spreadsheet
        • Presentation
        • Writer
        • PDF

        598 results for open 2 excel windows side by side office 2010

        A few efficient ways to handle large data

        A few efficient ways to handle large data

        09:14

        A few efficient ways to handle large data

        The main knowledge points of this lesson are the following 4 points。1. We can use the Freeze Pane, Eye Protection, and Reading Layout functions when processing tables with large data. 2. To view multiple worksheets in the same workbook simultaneously, we can use the New Window and View Side by Side functions or use the Split window function to work with multiple windows without interference. 3. To compare data, we can use the View Side by Side function, but it's easier and more con....

        Spreadsheet 11.1K views
        How to view two sheets side by side

        How to view two sheets side by side

        01:09

        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 sideFirst, 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....

        Spreadsheet 14.4K views
        How can we create a drop-down list

        How can we create a drop-down list

        01:33

        How can we create a drop-down list

        How can users quickly enter information in the table according to standard content? Drop-down list can help us to do that. Take this table as an example. Now we need to perfect the data in the “Gender” column. We can easily do that by using the drop-down list. 1. First, select the C2: C16 cell range.2. Then click the Insert Drop-Down List button in the Data tab. 3. We can select the Add choices drop down manually button in the popup dialog box and enter Male in the text box below. 4. T....

        Spreadsheet 42.6K views
        The Camera in WPS Spreadsheet

        The Camera in WPS Spreadsheet

        01:44

        The Camera in WPS Spreadsheet

        Today we will get to know the Camera in WPS Spreadsheet. With this feature, we can convert the table into a picture, and the contents of the picture will change as those of the table. Here are two sheets: Itinerary and Tour Route Planning Table. To make it convenient for comparison, we would like to place them side by side. Most people may choose to copy the data of the Tour Route Planning Table sheet and paste it into the Itinerary sheet. However, this is not a perfect way. First, we....

        Spreadsheet 8.6K views
        How to use Slide Master in WPS Presentation

        How to use Slide Master in WPS Presentation

        03:29

        How to use Slide Master in WPS Presentation

        WPS Office Suite is a high-performance and reliable office suite designed to protect data and information for both PC and mobile office software users.Slide Master can be the perfect fit for improving work productivity to uniform the fonts, background, and company logos when creating new slides. Without using Slide Master, every click with New Slide means creating a new blank slide with non-uniform formats. With the Slide Master function, we only need to set the background and font of ....

        Presentation 15.0K views
        How to quickly locate and replace data

        How to quickly locate and replace data

        02:12

        How to quickly locate and replace data

        When processing data in a Spreadsheet, we somtimes quickly need to locate the data among various data, or modify incorrect data in bulk. It would be convenient to use the Find and replace fucntion in WPS Spreadsheet. This video could be used in Microsoft Office Excel and Openoffice. Take the following table as an example, which records students’ grades on various subjects. Supposed that we want to find the E grade from the sheet. 1. Select all those ranges of cells that we want to find....

        Spreadsheet 153.5K views
        How to set the text fill in WPS Presentation

        How to set the text fill in WPS Presentation

        01:55

        How to set the text fill in WPS Presentation

        The various filling effects added to the text can beautify the slide while emphasizing the text. So, how can we add and set the text fill? Select the text, click the Text tool tab and the Text Fill button. Here, we can fill the text with different effects, including Solid fill, Gradient fill, Picture or texture fill and Pattern fill. We can choose from a variety of colors recommended by WPS Office for filling the text quickly with one click. If you want to choose more kinds of colors, ....

        Presentation 11.1K views
        How to insert equations in WPS Spreadsheet

        How to insert equations in WPS Spreadsheet

        01:53

        How to insert equations in WPS Spreadsheet

        You will be the amazing reporter with WPS Spreadsheet, which could be an alternative to Microsoft Excel. Mathematical equations contain a variety of number formats like symbols, scores, root numbers, and so on. It is difficult for us to enter these equations with the input method. However, with the Equation function in WPS Spreadsheet, inserting mathematical equations will no longer be a problem. Click the Insert tab at the top of the screen, then click the Equation button. Here, WPS O....

        Spreadsheet 21.2K views
        Prev 1 2 3 ... 74 75 Next
        WPS Academy
        Products
        WPS Office for Windows
        WPS Office for Mac
        WPS Office for Android
        WPS Office for iOS
        WPS Office for Linux
        Partners
        Links
        OEM Partners
        Strategic partners

        Follow us

        WPS Office Official Twitter

        WPS Office Official Facebook

        WPS Office Official YouTube