How To Format Cells in Google Sheets

Similar to Microsoft Excel, Google sheets allow you to make spreadsheets to store your data and create charts or graphs. Google’s version provides its users with a ton of formatting features, making it easier to create information that’s both descriptive and clear.

We’ll be discussing how to format the cells in Google sheets. All the formating can be done with the help of the ‘Format’ tab provided in the toolbar at the top of the sheet. We can also find some of the formatting options on the toolbar itself.

 

Formatting Google Sheets Cells

Follow the steps below to update how your information is presented in Google Sheets

  • Open your google spreadsheet. Enter the information if it is not already filled.
  • Click a cell, then drag your mouse across nearby cells you want to select, or hold  on a Mac or Ctrl on Windows and click another cell.
  • Go to the Format option in the above toolbar and apply the formatting options you’re interested in, to set up your data accordingly.

Options for Formatting Cells in Google Sheets

The following are the formatting options provided in your Google spreadsheets:

  • Undo Undo: This is to un-do something you have done. Suppose you changed the color of a cell from red to yellow, but you disliked the result. Clicking Undo will cancel the present action and the previous state is set to the whole document. Now we can go back to the color from yellow to red.

 

 

  • Redo Redo: This is similar to undo but, this time, we are re-doing it. Applying the action once again, imagine if we colored a column in red and we used Redo option to replicate this to other similar sets of cells
  • Bold Bold: We use this option to highlight the data in a cell or a collection of cells. When this action is chosen, the data appears in thick font. Here, we will make the first column bold.

 

 

  • Italic Italic: Selecting this option will make the data italic.

 

  • Strikethrough Strikethrough: This strikes off the data. The following is an example of a strikethrough formatting.

 

  • Font size: This option changes the font size of the data. The font size ranges from 6 to 36. In the following example, we formatted the size of the data in the cells with different font-size values.

  • Color text Change text color: To change the color of a text or data, we select this option. Some colors are red, blue, green, etc.

We changed the text color to red

  • Fill color Change cell fill color
    • Single color: Fills the selected cell(s) with the chosen color. In the following example, we filled the cell with three as data in red color

  • Borders Change cell borders
    • Border color Change border-color: This option allows us to change the border-color in our google spreadsheet. In the following example, we changed the border-color from normal black to blue.

    • Border style Change border-style: This option allows us to change the border-style in our google spreadsheet
  • Change horizontal text alignment: There are three further options in this option. Alignment towards left, center, and right. This will allow us to align the data in the cell(s) according to the chosen option.

Notice how the data in the cells are aligned to the center. We can also align the data to the left or right relative to the cells.

  • Change vertical text alignment: This is similar to the horizontal alignment but in the vertical direction.
  • Rotate text in a cell: This helps in rotating the cell – the data in the cell. If you’ll notice in the picture, we rotated the data in the cells clockwise. There are a variety of options to choose from in the rotate option.

Knowing where to find these formatting options and how to use them can give you the freedom to make each spreadsheet more personalized. As you adjust the way the data is presented, your work can be more learn and easier to follow. Try out some of these great options in Google Sheets today!

Get more Google Sheets stuff

Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.