Home>Article>Topics> Where to find positioning conditions in excel table

Where to find positioning conditions in excel table

醉折花枝作酒筹
醉折花枝作酒筹 Original
2021-04-27 11:23:40 23421browse

The positioning conditions in the excel table can be found in "Find and Replace". Specific search method: First open the Excel table that needs to be positioned, find the "Home" tab at the top of the page, select "Find and Replace"; then select "Positioning Conditions" in the pop-up drop-down list.

Where to find positioning conditions in excel table

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

The positioning conditions in the EXCEL table are in the "Find and Replace" settings.

The steps to open positioning are as follows:

Open the EXCEL table, find the "Edit" item in the "Home" tab, and click "Find and Replace".

Where to find positioning conditions in excel table

Select "Targeting Criteria" in the drop-down menu to open the targeting criteria.

Where to find positioning conditions in excel table

#Select the targeting criteria according to your needs in the targeting criteria, and then click the "OK" button.

Where to find positioning conditions in excel table

Related learning recommendations:excel tutorial

The above is the detailed content of Where to find positioning conditions in excel table. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn