598 results for open 2 excel windows side by side office 2010
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
598 results for open 2 excel windows side by side office 2010
A few efficient ways to handle large data
09:14A 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....
How to view two sheets side by side
01:09How 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....
How can we create a drop-down list
01:33How 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....
The Camera in WPS Spreadsheet
01:44The 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....
How to use Slide Master in WPS Presentation
03:29How 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 ....
How to quickly locate and replace data
02:12How 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....
How to set the text fill in WPS Presentation
01:55How 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, ....
How to insert equations in WPS Spreadsheet
01:53How 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....