How To Highlight On Google Sheets

Instead of highlighting words or numbers you are going to use the fill feature to highlight the entire cell column or row.

How to highlight on google sheets. Highlighting things in a spreadsheet is a bit different. Tap on the text and scroll down to find highlight colour option. From the panel that opens on the right click the drop down menu under format cells if and choose custom formula is. The beginner s guide to google sheets highlight all the cells inside the table and then click on format conditional formatting from the toolbar. So to highlight in google docs on android device select the area of the text and click on the letter a next to the sign.

Open your google sheets file and select the column or columns you want to sort. In the menu bar at the top select format in the dropdown menu select conditional formatting. Google sheets also has a built in feature that will remove duplicates completely. First obviously you are going to need to select whatever you wish to have highlighted. As for the selecting text you need to use the tap of your fingers instead of a mouse click.

Third party add ons are also available making finding and highlighting duplicates really easy.