Excel Tip – Quickly select all cells that Excel recognises as text

Sometimes you want to only select the entries in a list that are text in Excel particularly when you deal with a mix of numbers, texts, dates etc. To achieve this, highlight the entire area and press “Ctrl” + “G”, then click the “Special” button and select “Constants”. Make sure that only the entry under “Text” is ticked and then press “OK”.

Share this tip on