41 results for how to freeze pane in google sheets
- All Tutorials
- Video Tutorials
- Quick Tutorials
How can we freeze the pane in WPS Spreadsheet02:28
How can we freeze the pane in WPS Spreadsheet
When viewing a worksheet with a large amounts of data in the WPS Spreadsheet, we can't see the title row if we drag the scroll bar. Therefore, we won't be able to know exactly what each column of data represents. So how can we freeze a row or column for us to check it more conveniently? Today I'm going to introduce you to a practical feature, Freeze Panes. Take this table as an example. Click the Home tab, then click the Freeze Panes button. You can see that there are three....
How to customize animation02:21
How to customize animation
A well-formatted presentation file can better your speech, and properly adding animation effects can help capture the audience's attention. So how can we customize the animation? Take these slides as an example.1. Click the Animation tab at the top, then the Custom Animation task pane will pop up on the right side of the screen. Now we click Selection Pane.2. In the Selection Pane task pane, we can see all the elements of the current slide page.3. Click the eye icon on the right to....
How to freeze panes in WPS Spreadsheet
We can freeze the panes in three different ways.· Freeze to1. Select the cell below the rows and to the right of the columns that we want to freeze when scrolling.2. Click the Home tab → and then click the Freeze Panes button.3. Now click the first option in this drop down menu. · Freeze First Row1. Use WPS Office to open the form and click the Home tab → and then click the Freeze Panes button.2. Now click Freeze First Row.Then we can easily freeze the first row of this table. · Freeze....
How to split sheets by content01:16
How to split sheets by content
When you want to split the content based on the specific categories in the sheet, are you still disassembling and reorganizing the content one by one? The Split Sheet feature can help you. Take this sheet as an example. If we want to split this sheet into three sheets based on class 1, class 2 and class 3, what should we do? We just need to click the Home tab and click Worksheet, then click the Split Sheet option, finally choose Split Sheets By Content. In the Split area box, we can ch....
How to set a worksheet in WPS Spreadsheet03:53
How to set a worksheet in WPS Spreadsheet
The Worksheet feature of the WPS Spreadsheet can perform several basic operations on the table. So now I'm going to show you the usage of Worksheet feature that it could be also used in Microsoft Office Excel and Openoffice. · Insert SheetClick the Home tab, select Worksheet, then select Insert Sheet. Now we can set the number and position of the insert in the popup dialog box. Or we can also click the plus sign in the bottom column of the table to add directly.· Delete SheetClick....
How to insert and set a text box01:44
How to insert and set a text box
When using WPS Presentation, we often need to edit text content in the text box. So how can we insert a text box? First, click the Insert tab above and click the Text Box drop-down button. Here, we can choose to insert a Horizontal Text Box or a Vertical Text Box. This video of How to insert and set a text box will only take the horizontal text box as an example, which could be compatible with Microsoft Office powerpoint. Click Horizontal Text Box and then long-press the left mouse but....
How to use the spell-check function02:31
How to use the spell-check function
The spell-check function of WPS helps us to quickly check spelling mistakes and provides suggestions for corrections. It saves us a lot of time to align documents. We can see that some of the content of this document has been marked with red underlines because WPS Office judged that the content of the text is wrong. At this time, we need to correct the marked content to eliminate these red underlines.Click the Review tab and click the Spell Check button. A pane will pop up on the right....
How to set the text fill in WPS Presentation01: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, ....