HomeGoogleGoogle SheetsFormatting Cells

13.3. Formatting Cells

Directions: There are four options to view the resources below: try it, view it, watch it, or print it. Click the drop down menu titled "Try-It Interactive" to select your preferred viewing method. Then, click start.


15 STEPS

1. The first step is to open your Google Sheet and click the cell you want to format.

Step 1 image

2. The majority of my format options are found in the tool bar at top. We will start with Font size

Step 2 image

3. Click your desired font.

Step 3 image

4. Click Italic, Bold, or Strike Through to change the style of text in a cell (⌘I)

Step 4 image

5. Click the Horizontal align button to change where text lies within a cell.

Step 5 image

6. We will choose to center our text.

Step 6 image

7. Click Vertical align to change how the line height of text in a cell.

Step 7 image

8. We will place ours at the top

Step 8 image

9. If you have a cell with overhanging text, click said cell.

Step 9 image

10. Click the Text wrapping format button at top.

Step 10 image

11. We will click wrap text to ensure that our text will not hang off the side of the cell

Step 11 image

12. The font dropdown menu allows for basic font formatting. We will choose Comfortaa for cell A3

Step 12 image

13. Use the "More formats" options to change how numbers are displayed in a given cell. This is very helpful in turning decimals into percentages or vice-versa.

Step 13 image

14. Click the drop down menu next to 123 to see the full list of number formats for cells.

Step 14 image

15. That's it. You're done.You now know all the basics of editing cells in Google Sheets.

Step 15 image

Here's an interactive tutorial

https://www.iorad.com/player/1737412/Google-Sheets---Formatting-Cells--the-basics-



Downloads

Knowledge Tags