Google Sheets – Cell formatting

The fundamental building blocks of any spreadsheet are the cells. So, clearly it’s important to understand how to use them well. In this post I will focus on the various ways you can format cells, so that the cells display the information you want, visually look professional and most importantly, will help you understand your data.

Here’s the whole thing in a GIF. Below it are the step-by-step instructions.

Sheet2b

Adding cell borders

Here I have some data I’ve already inputted, but as you can see it’s not formatted very nicely. So, let’s change that.

1) Select all the data by clicking on cell A1, holding the mouse button and dragging the blue selection that will appear to cell B6, then release the mouse button. You should have all your data selected as per the second picture below.

Sheets2 - 1     Sheets2 - 2

2) On the menu shortcut toolbar, click on the borders icon.

Sheets2 - 3b

This opens a drop down menu with various borders options. The best way to think of the little icons is that they represent a grid of 2 columns and 2 rows. So, for example, the top right icon, will just add borders on the outside of the selection, but not add borders on the inside. The bottom left icon will only add borders to the far left cell and not the left-hand side of the second column.

3) I want to add borders to all the cells, so I’ll select the top-right icon.

Sheets2 - 4        Sheets2 - 5

4) As you can see it adds borders to all the cells in the selection. Just click on any cell to get rid of the blue selection.

Sheets2 - 6


Filling the cells with colours

Let’s add a bit of colour to the table.

1) Select the the top row (A1 to B1).

Sheets2 - 7

2) Click on the fill icon.

Sheets2 - 8 (1)

3) This opens the colour palette. Click on the colour you want.

Sheets2 - 9

4) The cells will fill with that colour.

Sheets2 - 11


Changing the position of the data in the cells

By default, text normally is automatically placed to the left of the cell and numbers are placed to the right.

Here I want to put the two column headers in the centre of the cells.

1) Select the two cells (A1 and B1).

Sheets2 - 10

2) Click on the justification icon.

Sheets2 - 12

3) A drop down menu will appear, offering 3 options. Put the data to the left, in the centre, or to the right. I want the centre, so I click on that one. As you see the headers of my table (in the top row) are now positioned in the centre.

Sheets2 - 13       Sheets2 - 14


Putting the data in bold

1) Select the two top cells as before, and then click on the bold icon “B”.

Sheets2 - 15

2) The headers are now in bold.

Sheets2 - 16


Changing the font, font size, and selecting text wrap

1) Select the text.

Sheets2 - 17

2) From the menu shortcut toolbar, click on the font menu (by default it’s “Arial”). A list of possible fonts will drop down. Yours may look different to this. Click on the font you want.

Sheets2 - 18

Sheets2 - 18b

3) Now, let’s change the font size. Click on the font size number, next to the font name. This drops down a menu where you can either select a size, or just type in a size in the box.

Sheets2 - 19

Sheets2 - 20

I selected size 14. If you notice, the cell with “Test average” is now too big for the cell. I could change the column width, but below I’m going to allow the text wrap within the cell.

5) Click on the text wrap icon.

Sheets2 - 21

6) This offers 3 options:

Sheets2 - 22

  • a) if the text is bigger than the cell, it goes across into the cell to the right (unless there is something in that cell)-this is the default
  • b) wrap the text so that all the text stays in the same cell and to do this, the row height changes
  • c) the text is clipped when it gets to the edge of the cell. Note, this is just a visual thing on the sheet, it doesn’t affect the content of the cell, i.e. the original text is still intact.

I want it to wrap the text, so I choose the middle option. Now I can see all the text.

Sheets2 - 23

The best way to learn these things, is to play around with the different options, with different sets of data.


eBooks available on Drive, Forms, Sheets, Docs, Slides, and Sheet Functions:

Baz Roberts (Flipboard / Twitter / Google+)


2 thoughts on “Google Sheets – Cell formatting

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s