162 results for open excel in separate windows
- All Tutorials
- Video Tutorials
- Quick Tutorials
More features in Screenshot01:56
More features in Screenshot
Both WPS Spreadsheets and Microsoft Excel have the function of a screenshot. What are the differences between them? In Microsoft, we can click the Screenshot drop-down button and select one of the Available Windows to take a screenshot. Click Screen Clipping to capture the screen by adjusting its size manually, and only the area outside the Excel document is available. In WPS Spreadsheets, we have two ways of screenshot for your selection.Option 11. Click the Insert tab, click the Scre....
More features in Screenshot02:02
More features in Screenshot
Both WPS Writer and Microsoft Word have the function of the screenshot. What are the differences between them? In Microsoft Word, two methods are available. One is Available Windows, which means to capture the opened windows on our desktop; the other is Screen Clipping. We need to capture the screen by manually adjusting its size in this mode, and only the area outside the Excel document is available. In WPS Writer, we can enter the Insert tab and click the Screenshot drop-down button.....
Use the Mail Merge function to input tabular data quickly01:49
Use the Mail Merge function to input tabular data quickly
WPS Office contains four major functional modules: Writer, Spreadsheet, Presentation, and PDF Converter. Easily compatible with 51 types, including doc, xls, ppt and other text types. Best free office suite alternative to Microsoft Office Word, Excel, and PowerPoint,applicable to Windows, mac OS, Android and iOS.Do you know how to make badges in batches? Are you still inputting employee information one by one? It's a waste of time. Today, we will learn how to use the Mail Merge fun....
More features in Picture to Text02:12
More features in Picture to Text
Both WPS Spreadsheets and Microsoft Excel have the function of Converting pictures to text. What are the differences between them? Microsoft Excel itself does not support the OCR function. If you want to convert Picture to Text, you need to open another application, OneNote. 1. Copy the picture and paste it into OneNote.2. Click Copy Text from Picture with the right mouse button3. Paste the text into Excel as needed. In WPS Spreadsheet, the OCR function allows us to convert pictures to....
How to split sheets quickly01:26
How to split sheets quickly
In WPS Spreadsheets, there are two ways of splitting sheets: Split Sheets By Content and Split Books By Sheet. First, Split Sheets By Content.Take this table as an example. We want to split this table into multiple sheets by month. Click the Data tab, click the Split Sheet drop-down button and select Split Sheets By Content. The default Split area is the whole table. Check My data has headers to make the split sheets have titles. Since we want to split the table by month, we select "Mo....
Split Books by Sheet01:09
Split Books by Sheet
Do you know how to split your worksheet?Take this table as an example. Seeing the sales performance from January to July, we need to split the monthly sales into individual workbooks and send them to the leader. It is too cumbersome to copy and paste the data one by one and generate new files. Fortunately, we can use the function of Split Books by Sheet. In this table, we click the Data tab, then click the Split Sheet drop-down button, and select Split Books By Sheet in the drop-down m....
How to merge and split PDF files01:25
How to merge and split PDF files
WPS PDF could help edit PDF files and freely convert between PDF and Word, Excel, PowerPoint, and JPG files online. When editing PDF files, we often need to merge multiple PDF files or split a PDF file. So how can we do that?· Merge PagesTake this file as an example. When we need to merge multiple PDF files into one, click the Page tab, then click Merge Page. Now the WPS PDF to Word Converter dialog box will pop up. Click the Add files button in the upper right corner and select other ....
More features in Splitting Columns03:06
More features in Splitting Columns
When several pieces of information are filled in one cell, we often need to split it into multiple columns, and both WPS Spreadsheets and Microsoft Excel support splitting columns. Take this table as an example. In Microsoft Excel, we select the cell range of A2:A11, click the Data tab, click Text to Columns, and we can choose Delimited or Text Width to split columns manually. In addition to this original method, WPS Spreadsheets has a new feature, namely, Smart Split Columns. It has t....