How to Work Smarter with Excel on PC/Mobile: Freeze panes/Find/AutoFilter

How to Work Smarter with Excel on PC/Mobile: Freeze panes/Find/AutoFilter

October 14, 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

2-1

WPS Spreadsheet Mobile

WPS Office for Android contains four major components: Writer, Presentation, Spreadsheets and PDF reader.

2-2

Wondering what you could do with the WPS spreadsheet on your phone? The answer is EVERYTHING! For the next minute, we will walk you through on how to Freeze Panes, 'Find', and AutoFilter in the WPS spreadsheet mobile. Three powerful features you must have to an easy, efficient way to work.

Let's get right into it 👉
6-1
3-1

  1. Find the Menu bar at the left bottom.
  2. Select the 'View' option.
  3. Scrolling down to find 'Freeze Panes'.
    *To freeze rows of your choice, select the row/rows and then click on the option "Freeze torow".

FP

14-18-2

  1. Same steps to locate 'View' option.
  2. Select 'Find'.
  3. Enter value.

find


13-3

10-2

  1. Same steps to locate 'View' option.
  2. Turn 'Filter' on.
  3. Select the column you wish to filter.
  4. Enter value
Result:

11

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.