Partial Cell Format in Google Sheets

Various previous posts have dealt with cell formatting in Google Sheets..

Google has now upgraded this feature so it’s now possible to select a portion of the text within a cell and to apply formatting to only those characters, instead of to the entire cell. This new feature is available both on the web and in the Sheets app for Android.

Let’s use a simple example:

Click image to enlarge

Click image to enlarge

Click in the cell containing the text to be formatted, then highlight the portion of that text you wish to format, and use the formatting tools to edit how it is displayed:

Click image to enlarge

Click image to enlarge

When you’re done, the text will display with all of the partial formats you’ve introduced:

Click image to enlarge

Click image to enlarge