Cell alignment and wrapping in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does cell alignment control in Google Sheets?

Cell alignment controls how the content inside a cell is positioned horizontally or vertically, such as left, center, or right alignment.

beginner

How do you wrap text in a cell in Google Sheets?

You can wrap text by selecting the cell, then clicking the 'Text wrapping' button in the toolbar and choosing 'Wrap'. This makes all text visible by breaking it into multiple lines inside the cell.

beginner

What happens if you don't wrap text and the content is longer than the cell width?

The text will either overflow into adjacent empty cells or be cut off if the next cell has content, making some text invisible.

beginner

Which alignment option would you use to center text vertically in a cell?

You would use the vertical alignment option and select 'Middle' to center text vertically inside the cell.

beginner

True or False: Wrapping text changes the width of the cell automatically.

False. Wrapping text changes the row height to fit the text but does not change the cell width automatically.

What does the 'Wrap' option do in Google Sheets?

A Breaks text into multiple lines inside the cell

B Makes text overflow into adjacent cells

C Cuts off text that is too long

D Changes the font size automatically

The 'Wrap' option breaks text into multiple lines inside the cell so all content is visible.

Which alignment option places text at the right edge of a cell?

A Left align

B Right align

C Justify

D Center align

Right align places the text at the right edge of the cell.

If a cell's text is not wrapped and is longer than the cell width, what happens if the next cell is empty?

A Text shrinks to fit

B Text is cut off

C Text overflows into the next cell

D Text is hidden

Text will overflow into the next empty cell if wrapping is off.

How can you vertically center text in a Google Sheets cell?

A Use vertical alignment middle

B Use horizontal alignment center

C Use text wrapping

D Change font size

Vertical alignment middle centers text vertically inside the cell.

Does wrapping text in a cell change the cell's width automatically?

A Yes, it widens the cell

B No, it changes the column width

C Yes, it narrows the cell

D No, it changes the row height instead

Wrapping text changes the row height to fit the text but does not change the cell width.

Explain how to align text both horizontally and vertically in a Google Sheets cell.

Think about the toolbar buttons for alignment.

Describe what text wrapping does and why it might be useful in a spreadsheet.

Consider what happens when text is too long for a cell.