How to Search Google Sheets (PC or Mac)

Table of contents:

How to Search Google Sheets (PC or Mac)
How to Search Google Sheets (PC or Mac)
Anonim

This wikiHow teaches you how to search for a word, phrase, number, or character in a spreadsheet using a desktop browser.

Steps

Search in Google Sheets on PC or Mac Step 1
Search in Google Sheets on PC or Mac Step 1

Step 1. Open Google Sheets using a browser

Type sheets.google.com in the browser address bar and press Enter on your keyboard.

If the login does not happen automatically, enter your e-mail address or telephone number, then click on "Next", enter the password and click on "Next" again

Search in Google Sheets on PC or Mac Step 2
Search in Google Sheets on PC or Mac Step 2

Step 2. Click on a spreadsheet in the list of saved files

Search for the spreadsheet you want to search in and open it.

Search in Google Sheets on PC or Mac Step 3
Search in Google Sheets on PC or Mac Step 3

Step 3. Press the key combination that allows you to access the search function

This will open the search box in the upper right corner.

  • On Windows you have to press Control + F.
  • On a Mac you have to press ⌘ Command + F.
Search in Google Sheets on PC or Mac Step 4
Search in Google Sheets on PC or Mac Step 4

Step 4. Enter one or more words to search

In the search box you can type a keyword, a number, a symbol or multiple words. All relevant cells will be selected in the spreadsheet.

Search in Google Sheets on PC or Mac Step 5
Search in Google Sheets on PC or Mac Step 5

Step 5. Press the icons

Android7expandless
Android7expandless

And

Android7expandmore
Android7expandmore

to see the next result.

These buttons are located next to the search box in the upper right corner and allow you to switch between cells.

  • Alternatively, you can press Enter on your keyboard. This method has the same function as the key

    Android7expandmore
    Android7expandmore
Search in Google Sheets on PC or Mac Step 6
Search in Google Sheets on PC or Mac Step 6

Step 6. Click on the three dots icon next to the search box

This will open the advanced search options in a new pop-up window.

Search in Google Sheets on PC or Mac Step 7
Search in Google Sheets on PC or Mac Step 7

Step 7. Click the Find button

This way the keywords will be searched in the spreadsheet. Each time you press the "Find" key, you will be able to move to the next cell that contains the word or words you are looking for.

Recommended: