Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How To Create Frequency Distribution in Excel
  • Randomize/ Shuffle List in Excel
  • How to do a t-Test in Excel?
  • How to Use Solver Tool in Excel
  • How to Create One and Two Variable Data Tables in Excel

References

  • Two-column Lookup in Excel
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • Count rows with at least n matching values
  • How to use Excel VLOOKUP Function
  • How to use Excel OFFSET function

Data Validations

  • Excel Data validation only dates between
  • Excel Data validation date in next 30 days
  • Excel Data validation must begin with
  • How To Create Drop-down List in Excel
  • Excel Data validation must contain specific text

AutoFit Column Width, AutoFit Row Height in Excel

by

You probably know how to change the width of a column in Excel, but do you know how to automatically fit the widest entry in a column?

AutoFit Column Width

The default width of a column is 64 pixels.

1. You can change the width of a column by clicking and dragging the right border of the column header.


2. To automatically fit the widest entry in a column, double click the right border of a column header.


3. To autofit multiple columns, first select multiple columns by clicking and dragging over the column headers.

Note: to select non-adjacent columns, hold CTRL while clicking the column headers.

4. Next, double click the right border of one of the column headers.

5. To change the width of all columns, first select all columns by clicking the Select All button.

6. Next, change the width of a column.

AutoFit Row Height

The techniques described above can also be used to change the height of a row. Instead of clicking the right border of a column header, simply click the bottom border of a row header. There’s one more way to autofit columns or rows.

1. First, select multiple rows by clicking and dragging over the row headers.

2. On the Home tab, in the Cells group, click Format.

3. Click AutoFit Row Height.

Result:

Note: you can also use this technique to set a row height or a column width (see screenshot at step 3). Be careful, don’t think in pixels here. The default width of a column is 8.43 units and the default height of a row is 15.00 units.

Post navigation

Previous Post:

VLOOKUP without #N/A error in Excel

Next Post:

Manipulating text strings using Left, Mid, Right, Len, Substitute in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • How to use Excel FALSE Function
  • SWITCH function: Description, Usage, Syntax, Examples and Explanation
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • IFERROR function: Description, Usage, Syntax, Examples and Explanation
  • How to use IFS function in Excel

Date Time

  • HOUR function: Description, Usage, Syntax, Examples and Explanation
  • EDATE function: Description, Usage, Syntax, Examples and Explanation
  • Get month from date in Excel
  • Convert decimal minutes to Excel time
  • Convert decimal hours to Excel time

Grouping

  • How to randomly assign people to groups in Excel
  • Group numbers with VLOOKUP in Excel
  • Map inputs to arbitrary values in Excel
  • Group times into 3 hour buckets in Excel
  • Group numbers at uneven intervals in Excel

General

  • How to increase by percentage in Excel
  • Creating and Opening an existing file in Excel
  • Subtotal by color in Excel
  • Find, Select, Replace and Go To Special in Excel
  • Share Excel data with Word documents
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning