One of my biggest regrets when I first got started with Google Sheets and spreadsheets in general, was not taking full advantage of Find and Replace.
Find and Replace is the penicillin of the Spreadsheet world. It can rapidly cure all sorts or issue with a simple set of commands. It is seriously amazing stuff.
Yeah! Yeah! We all know about Find and Replace.
I know! I thought so too, but then I started to really use and identify how I could use it to quickly:
- Change template sheets.
- Fix bulk errors in formulas.
- Change parts of cells.
- Replace values in the whole spreadsheet, one sheet or a selected range.
Before we get started, you need to know the short cut for the Find and Replace tool. This will come in handy in all sorts of programs and apps.
- PC – Ctrl + H
- Mac – CMD (⌘) + H
I’m going to go ahead and continue the examples using PC, because, you know, Mac.
Continue reading “Multiple Cell Data and Formula Reference With Find and Replace – Google Sheets”