How to Work Smarter with WPS Office Spreadsheet: Freeze panes/Find/AutoFilter

How to Work Smarter with WPS Office Spreadsheet: Freeze panes/Find/AutoFilter

July 24, 2020

Me scrolling back and forth the page to match up each data with correct title bar:

200w-4

Often, when the sheet contains vast amounts of data, it is very inconvenient for users to edit, select, or logging. Have you ever wondered how much time saved if you can just pin that title bar at the top?

Good news, it's a piece of cake! Just keep on reading to learn how to solve the problem with WPS Office.

3
9

Freeze Panes

Freeze panes are a very practical function daily. By having a few top rows froze, it allows you to keep rolling down with the visibility of the top bars.

4-1

  1. Click the "Freeze Top Row"
  • To freeze rows of your choice, select the row/rows and then click on the option "Freeze torow".

200w-4-copy


9

Locate Data

There are two options to choose from:
5
146

And then this window will pop up.
7

  • Note: You can either select one result and click on the option, or type "Ctrl+A" to select everything.

13-1
AutoFilters provide a quick way to find and work with a subset of data in a range or table. When you filter a list, you temporarily hide some of the data, so you can focus on the data you want.

Follow these steps to apply the AutoFilter:9-1
8-1

Result:

10-1

9-2
12-1

To download WPS office, go check out WPS offcial website.

It’s now in 2020. It’s WPS way of working.

About Author

International operations department for WPS Office.