Feature Summary

The Find, Replace, and Go To features are used to quickly locate or batch-modify specific text and numeric content in AirSheet, improving users' search and editing efficiency when processing large amounts of data.

Feature Description

Feature Dimension Description
Membership Restriction No membership restriction
Version Restriction No version restriction

Operation Steps

Using the Find Feature

Feature Entry
"Home" tab → "Find" button / Shortcut Ctrl+F

  1. Press the Ctrl + F shortcut, or click the "Find" button in the Home tab
  2. Enter the content you want to find in the find box
  3. Click "Next" to jump to the matching cell
  4. Click "Find All" to view a list of all matching results

image

Using the Replace Feature

Feature Entry
"Home" tab → "Find" button dropdown menu → "Replace" / Shortcut Ctrl+H

  1. Press the Ctrl + H shortcut, or click the "Find" button dropdown menu in the Home tab → "Replace"
  2. Enter the original content in the "Find" input box
  3. Enter the new content in the "Replace with" input box
  4. Click "Replace" to replace one by one, or click "Replace All" to batch replace

image

Using the Go To Feature

Feature Entry
"Home" tab → "Find" button dropdown menu → "Go To" / Shortcut Ctrl+G

  1. Press the Ctrl + G shortcut, or click the "Find" button dropdown menu in the Home tab → "Go To"
  2. Check the required content for different types of Go To

image

Advanced Find Options

Feature Entry
Find/Replace dialog → "Options" button

  1. Click the "Options" button in the Find/Replace dialog to expand advanced settings
  2. Configurable options include:
  • Search Scope: sheet or workbook
  • Match Case: match case precisely
  • Match Entire Cell Content: match the entire cell content (rather than partial match)
  • Search by Rows/Columns: control the search direction

image

FAQ

Q1: How to find content in multiple sheets simultaneously?

  • Solution: In the Find dialog, click "Options" and change the search scope from "Sheet" to "Workbook" to find content across all sheets in the entire workbook.

Notes

  • Using format-based find allows you to precisely locate content with specific formatting in complex sheets