Google Sheets Shorts : Find and Replace (37)

Using Find and Replace is one of our Bread and Butter tools in Google Sheets. Fortunately, Google Sheets offers a lot of versatility for you to cleverly find and replace exactly what you need.

In this tutorial, we will cover, 00:00 Intro. 00:09 the basic Find tool. 02:07 Understanding the Find and Replace tool. 02:48 Using Find in the Find and Replace popup. 03:12 Basic Find and Replace 03:41 Seaching in specific ranges, sheets or the entire workbook. 06:51 Find case senstive cells. 08:02 Undoing your replace. 08:20 Find cell that matches exact string 09:39 Search using regular expressions 13:45 Search for values inside formulas.

#GoogleSheets #Spreadsheets #SpreadsheetBasics #GoogleEDU #GoogleWorkspace

Even knowing the basics can really give you the edge and save you a heap of time in the workplace.

If you like the video, check out my website: https://yagisanatode.com/

Here is the link to just Google Sheets tutorials: https://yagisanatode.com/google-sheets/

Sign up for my course: Google Sheets: Learn the Essentials with Three Detailed Projects https://yagisanatode.teachable.com/p/google-sheets

Grab a Google Sheets Shortcuts Mousepad to help you memorise the Shortcuts. https://www.zazzle.com.au/collections/shortcuts_mousepads-119754792503977450 ... https://www.youtube.com/watch?v=-8LRAVWKSoc