Join Dennis Taylor for an in-depth discussion in this video Adjust one or more row heights and column widths without commands, part of Excel: Introduction to Formatting.
- [Instructor] Anytime you need to adjust the width…of one or more columns, or the height of one or more rows,…it's likely to be easier to avoid the ribbon menu system…even though there are commands available,…and use double-clicking and dragging techniques.…We're looking at a worksheet, it's called RowColumnSizing,…in our chapter four workbook called RowColumnAdjustments.…A quick glance here suggests column A…is wider than is necessary, column B's not wide enough,…column E has something you might recognize.…When a column with numeric entries is too narrow,…those numeric entries turn into hashtags.…
We can't read the numbers here.…Now, there are standard techniques,…and for the record, if we wanted to adjust for example,…just column E, we could go to the home tab off to the right,…there's format, and we probably would choose…in a case like this, AutoFit Column Width.…But we don't really need to use these commands very much.…Let me undo that with Control + Z.…First of all, we can adjust…each column as necessary one-by-one,…
- Controlling fonts, borders, colors, and alignment
- Adjusting numeric formats quickly
- Accentuating dynamic data with conditional formatting
- Adjusting rows and columns