You can combine data in cells to make it look better on your sheet. In this video, learn how to merge and unmerge cells.
- [Instructor] You can merge cells together … to make data in only one cell look better. … Click and drag to select all the cells … that you wish to merge … and on the toolbar click Select merge type. … I'll choose to merge these horizontally. … Now I can align the cell, such as centering it. … To unmerge the cells, select your merged cell … and choose Unmerge. … This works for both columns and rows, … though if you do merge cells … that have more than one item in it, … it's only going to keep the uppermost value … and delete the rest. … I'll click Merge again, … except I'm being told that it's only going to preserve … the top leftmost value. … Click OK and my cells are merged. … …
- Wrapping text
- Collaborating with others on a spreadsheet
- Freezing and locking panes
- Auto-filling data quickly
- Rotating cell data
- Formatting spreadsheets
- Protecting sheets
- Inserting links
- Filtering views
- Undoing unwanted changes
Skill Level Intermediate
1. Google Sheets Quick Tips
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.