Join David Rivers for an in-depth discussion in this video Merging cells, part of Learn Excel for Mac 2016: The Basics.
- When you're adding content to a cell…that's going to be much bigger than the cell can contain,…we already know looking at our Landon Hotel title here,…that it's going to overlap the cells…that are next to the cell you're typing in.…Let's click in cell A1 here.…There's the entire contents…and it is spilling over into cells B, C, D,…even into E1,…and we continue to see the entire title…only because there's nothing in those cells.…Otherwise, it would get cut off.…So a better option is to merge cells together…into one big cell, or simply widen the column…to accommodate the entire title.…
That doesn't make sense for our spreadsheet…so merging the cells together is what we want to do.…If you were following along with me in the previous movie,…we zoomed in a little bit…and experimented with freezing panes,…our first column, and a number of rows at the top.…Let's zoom back out.…I'm going to use the - sign to go back…to around 100 percent, let's say,…where we can see all of our columns…all the way to the Totals column in column N.…
- Create new workbooks
- Work with text
- Add formulas and functions
- Use Auto Fill
- Format data
- Manage rows and columns
- Share and print workbooks
Skill Level Beginner
1. Getting Started with Excel 2016
2. Modifying Worksheets
3. Sharing and Printing Workbooks
Printing workbooks3m 22s
- 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.