New Feature: Playlist Center! Pick a topic and let our playlists guide the way.

Start learning with our library of video tutorials taught by experts. Get started

Excel 2013 Power Shortcuts
Illustration by Neil Webb

Wrapping and shrinking cell text


From:

Excel 2013 Power Shortcuts

with Curt Frye

Video: Wrapping and shrinking cell text

One of the hardest parts of creating an Excel worksheet is to get the design exactly the way you want it. That means that you need to get the appearance right, but it also means that you need to have the size of the cells exactly right so that they print properly. In this movie, I'll show you how to work with the cells' contents, so that you can stay within the boundaries of your existing design. I will use the WrapText sample file, which you can find in the Chapter 5 folder of your Exercise Files archive. The cell's content that I'm interested in working with is in cell B2.
Expand all | Collapse all
  1. 2m 1s
    1. Welcome
      59s
    2. What you should know before watching this course
      25s
    3. Using the exercise files
      37s
  2. 32m 35s
    1. Entering numbers with leading zeros
      4m 15s
    2. Entering a data series using the fill handle
      4m 40s
    3. Adding text to a number format
      2m 57s
    4. Printing a sheet on a set number of pages
      2m 51s
    5. Using an Excel table column as a named range
      3m 17s
    6. Numbering rows in a range or table
      2m 44s
    7. Creating hyperlinks to other resources
      3m 37s
    8. Analyzing data using the Quick Analysis Lens
      2m 55s
    9. Super-hiding worksheets
      3m 39s
    10. Creating recommended PivotTables
      1m 40s
  3. 16m 33s
    1. Controlling the user interface using your keyboard
      3m 26s
    2. Customizing the Ribbon
      4m 57s
    3. Customizing the Quick Access Toolbar
      3m 46s
    4. Finding commands not on the Ribbon
      2m 16s
    5. Hiding sheet tabs and scrollbars
      2m 8s
  4. 13m 48s
    1. Moving among worksheets quickly
      1m 57s
    2. Displaying a workbook's full path
      2m 6s
    3. Setting the number of worksheets in a workbook
      1m 59s
    4. Limiting a worksheet's scroll area
      2m 26s
    5. Setting a print area
      2m 32s
    6. Zooming in or out quickly
      2m 48s
  5. 22m 59s
    1. Creating a custom view
      4m 16s
    2. Creating a table using Ctrl+L
      2m 54s
    3. Applying a table style and replacing existing formatting
      2m 48s
    4. Creating a linked picture of a range
      3m 26s
    5. Finding a target value
      3m 24s
    6. Creating substitute data sets using scenarios
      6m 11s
  6. 24m 22s
    1. Entering a line break in a cell
      1m 54s
    2. Wrapping and shrinking cell text
      2m 32s
    3. Entering data into every cell in a range
      2m 39s
    4. Picking data from a list
      1m 40s
    5. Entering data into cells across multiple sheets
      2m 26s
    6. Entering data using an AutoCorrect value
      3m 1s
    7. Creating a data entry form
      3m 25s
    8. Finding a specific color using RGB values
      2m 33s
    9. Basing conditional formats on a formula
      4m 12s
  7. 13m 3s
    1. Extending a date series
      3m 47s
    2. Using a custom list with the fill handle
      3m 37s
    3. Using Flash Fill to manage data
      2m 5s
    4. Removing duplicate values
      3m 34s
  8. 13m 8s
    1. Inserting the current date or time
      2m 44s
    2. Displaying times that exceed twenty-four hours
      2m 49s
    3. Calculating days between dates
      2m 23s
    4. Calculating time to reach an investment goal
      2m 38s
    5. Displaying thousandths of a second
      2m 34s
  9. 21m 39s
    1. Generating a list of unique random numbers
      3m 48s
    2. Using INDEX and MATCH to look up data without using the left-most column
      5m 47s
    3. Summarizing data on the status bar
      2m 29s
    4. Rounding values
      6m 30s
    5. Calculating remainders and whole units
      3m 5s
  10. 17m 37s
    1. Calculating running totals
      1m 55s
    2. Creating and selecting named ranges quickly
      3m 27s
    3. Commenting within a formula
      2m 28s
    4. Displaying a cell formula using FORMULATEXT
      1m 54s
    5. Exiting a cell without saving changes
      1m 28s
    6. Analyzing a formula for errors
      3m 9s
    7. Watching a cell's value
      3m 16s
  11. 18m 17s
    1. Creating a chart by pressing one key (or two)
      1m 34s
    2. Creating recommended charts
      1m 37s
    3. Summarizing data using a sparkline
      3m 44s
    4. Using a PivotTable value in a formula
      3m 44s
    5. Delaying PivotTable updates
      2m 28s
    6. Creating separate sheets from a PivotTable
      3m 5s
    7. Drilling down into PivotTable data
      2m 5s
  12. 56s
    1. Additional resources
      56s

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
please wait ...
Excel 2013 Power Shortcuts
3h 16m Intermediate Feb 28, 2013

Viewers: in countries Watching now:

Discover over 65 tips, tricks, and shortcuts in Microsoft Excel. In this course, Curt Frye reveals how to invoke commands, manage and organize data, and build formulas in Excel. Curt shares his power shortcuts for saving time on basic tasks, from entering data and selecting cell ranges to summarizing data with charts and tables and quickly finding information.

Topics include:
  • Entering a data series using the fill handle
  • Creating hyperlinks
  • Setting a print area
  • Applying a table style
  • Creating substitute data sets using scenarios
  • Wrapping and shrinking text
  • Creating a data entry form
  • Removing duplicate values
  • Inserting the current date or time
  • Generating a list of unique random numbers
  • Calculating running totals
  • Analyzing a formula for errors
  • Summarizing data with charts and PivotTables
Subjects:
Business Spreadsheets
Software:
Excel Office Office 365
Author:
Curt Frye

Wrapping and shrinking cell text

One of the hardest parts of creating an Excel worksheet is to get the design exactly the way you want it. That means that you need to get the appearance right, but it also means that you need to have the size of the cells exactly right so that they print properly. In this movie, I'll show you how to work with the cells' contents, so that you can stay within the boundaries of your existing design. I will use the WrapText sample file, which you can find in the Chapter 5 folder of your Exercise Files archive. The cell's content that I'm interested in working with is in cell B2.

And you can see that with the existing design of the worksheet, with the width of cell B2, which I don't want to change, the contents, which you can see on the Formula barm are not all displayed inside of the cell. So what can I do to change that? Well, the first thing I can do is click cell B2, and then on the Home tab of the Ribbon, in the Alignment group, click Wrap Text. What that does is leave the width of the cell unchanged, but it finds a place to insert a break into the cell contents so that it wraps around.

And as you can see, all the cell's contents appear within the body of the cell. The compromise that was made is that the cell is now taller than it was before. If you're okay with the row being taller than the rows around it, then you can use the Wrap Text option. Let's suppose that doesn't work. Let's suppose that you don't want the cell boundaries to change at all. If that's the case, then you can shrink the text so that it will fit within the cell. I'll show you how to do that, but the first thing I'll do is click the Wrap Text button to remove that effect, so now, once again, the text doesn't fit.

And then with cell B2 selected, on the Home tab of the Ribbon, I'll click on the Alignment group's dialog box expander. That displays of the Alignment tab of the Format Cells dialog box. In the Text control group, the middle option is Shrink to fit. I'll check that box and click OK. Doing so reduces the size of cell B2's contents until they fit inside of the cell. So in other words, the cell boundaries didn't change either in the vertical or horizontal direction; the compromise was made by reducing the type size of the data inside the cell.

So again, you can use Wrap Text if you don't mind having your cell increase in size vertically, or, if you don't want the cell to change at all, you can use Shrink to fit and get it all in there and have it all be visible.

There are currently no FAQs about Excel 2013 Power Shortcuts.

 
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.
Upgrade now


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

join now Upgrade now

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.


Mark all as unwatched Cancel

Congratulations

You have completed Excel 2013 Power Shortcuts.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Notes cannot be added for locked videos.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.