Mobile Excel How to find content quickly by keyword

Recently, MO learned that many friends often have to work with Excel forms on mobile phones. "How do you import Excel tables from your computer into your phone?" Can my phone open an Excel form? " and "How to quickly find what you want on your phone?" Such questions reflect a growing number of people using mobile devices such as mobile phones to work with Excel tables.

For the first two issues, MO do not repeat. Today with Mo, with the help of Mo's old partner HTC G7 to see, in the WPS mobile version, what method to quickly find the content.

WPS Mobile version of the application is designed for mobile office people to create full-featured office software, mainly used in Android mobile phones, tablets and other mobile devices. Now, the WPS Mobile version enabled a new interface style, followed by a clear view of the photo wall display mode.

Open the WPS Mobile version of the mobile application. Locate the appropriate Excel document. The interface is shown in the following illustration.

WPS Mobile Version Home photo Wall display effect

A mo with the "2006 High two Grade" document as an example, to find the contents of the Excel document operations. The first step, open this document, find the "Find" button in the navigation bar, and click to see "Find replacement Function", where the main reference to the use of "find", the use of "replace" is not a table.

Enter the text "Zhengkiang" you want to find in the search field. Click the Magnifier search icon. As shown in the following figure.

WPS Mobile version of Excel content lookup feature screenshot

See here, some students may find, why I entered the keyword but did not find the results of the hint? Let MO to answer for everyone. Because the WPS Mobile Lookup feature is found by default under three conditions such as sheet, row, and value. Therefore, we need to set the conditions for the query according to need.

The following figure shows the optional settings for the three query criteria.

Three conditions for pre-set content lookup

A clang! Finally found the content that I wanted. In this "2006 High two Results" document, there are a total of several sheet, the following figure shows the "Class seat" sheet contains "Zhengkiang" content.

WPS Mobile Version Content search results screenshot

"Hint":

The difference between a workbook and a worksheet is that the former lookup range contains multiple sheet in a single Excel document, which refers to a single sheet in a single Excel document.

WPS Office Mobile version is the Kingsoft Office software launched, running on the Android platform full-featured Office software, support to view, create and edit a variety of commonly used Office documents, user-friendly mobile phones and tablets to use. Office document operations are under control as you meet any and all office requirements.