How to create conditional formatting in Google Sheets The easiest way to set conditional formatting on Google Sheets is by using the Format option in the Google Sheets toolbar.

Google Sheets overrides the original data. If you want to use full names later, copy the rows, paste them to another column or sheet, and run the Split text to columns function.

If your business stores spreadsheet data on Google Docs, you can copy blocks of information from one spreadsheet to another. The Google Docs Web Clipboard makes that easy.