Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • Extract data with helper column in Excel
  • Lookup entire row in Excel
  • How to use Excel FORMULATEXT function

Data Analysis Examples

  • How to conditionally sum numeric data in an Excel table using SUMIFS
  • Create Scatter Chart in Excel
  • How to Use Solver Tool in Excel
  • Use Data Form to input, edit and delete records in Excel
  • Get column name from index in Excel Table

Data Validation Examples

  • Excel Data validation allow weekday only
  • Excel Data validation allow uppercase only
  • Excel Data validation must not contain
  • Excel Data validation date in specific year
  • Excel Data validation with conditional list

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.

Worked Example:   Cell References: Relative, Absolute and Mixed Referencing Examples


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.

Worked Example:   How to test a range for numbers in Excel

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.

Worked Example:   How to get address of first cell in range in Excel

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:

How to use Union and Intersect operators in Excel

Next Post:

Fibonacci Sequence 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
  • Split numbers from units of measure in Excel
  • Join cells with comma in Excel
  • TEXTJOIN function: Description, Usage, Syntax, Examples and Explanation
  • How to count line breaks in cell in Excel worksheet
  • Count Number of Words in Excel
  • Convert date string to date time in Excel
  • How to get Weekdays, Working days between Two Dates in Excel
  • How to calculate Day of the Year in Excel
  • ISOWEEKNUM function: Description, Usage, Syntax, Examples and Explanation
  • Convert text timestamp into time in Excel
  • How to calculate present value of annuity in excel
  • PRICEDISC function: Description, Usage, Syntax, Examples and Explanation
  • NPV function: Description, Usage, Syntax, Examples and Explanation
  • TBILLEQ function: Description, Usage, Syntax, Examples and Explanation
  • Calculate periods for annuity in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles