Home  >  Article  >  Software Tutorial  >  A simple tutorial on finding content in Excel

A simple tutorial on finding content in Excel

王林
王林forward
2024-04-17 11:46:08406browse

Click the [Find and Select] icon on the right side of the start option box above, or directly use the shortcut key CTRL F to open the window.

Input the content you want to find in the pop-up search window, click [Options] to display the advanced search, where you can set the search range and whether to be case-sensitive. In the format, you can set to search by cell format, such as searching for all dates in it.

A simple tutorial on finding content in Excel

Click Search All to display all query results in the table. Click the search results below to quickly jump to the location of the content.

A simple tutorial on finding content in Excel

The above is the detailed content of A simple tutorial on finding content in Excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact admin@php.cn delete