How to resize columns and rows in Excel (2 steps)

Learn how to stretch, readjust or enlarge columns and rows in your MS Excel worksheet!

Tired of seeing this in your Excel worksheet: ##### ? Is your text so long it does not fit your columns anymore? Are you adjusting each column length and row height one at a time?

Discover the best methods to stretch columns and rows easily in Microsoft Excel!

Stretching columns for your text to fit will become a quick and easy task after discovering our tips. Ready to become an Excel expert thanks to Ted Jordan? Let’s go!

If you want to stretch perfectly each column and row to fit your text, follow simply these 2 steps:

  • Step 1: Select the columns or rows you want to adjust perfectly.
  • Step 2: Double-click the separation between them.

ExampleAdjusting one column

In this situation, the text in Column D does not fit and we can’t read it. Instead, we see these symbols: ###### .
We select column D and we double-click the right columns separator: column D now measures the perfect length!

>>>

All Excel columns fit perfectly.

Example – Adjusting several columns

Here we want to stretch all columns to best fit the content inside them. We select all the columns and we click on any separator between them.

2 columns in Excel need to be readjusted. We can't read the text in one of them.

>>>

Now all columns have the perfect fit.

Use the same techniques to adjust rows in your Excel sheet.

Another option to stretch your columns is to select them and to drag them to the size you want. You can do this in 2 steps:

  • Step 1: Select all the columns you want to adjust.
  • Step 2: Click one of the separators within your selection and drag it to the right to expand columns size.

Example

In this example, we want to resize all columns to the same length. We select all the columns and we click on any separator between them to stretch columns size.

The best method to fit automatically rows and columns in Excel in this one:

  • Step 1: Click the triangle on the top left corner of your worksheet.
  • Step 2: Double-click one of the row separators.
  • Step 3: Double-click one of the column separators.

Now all your worksheet is autofit to the best size for each row and each column.

Row 3 and columns D, E and F need to be readjusted in size. Click on the triangle to select the entire sheet (you can also press Command+A).

Double-click any rows delimiters: rows are now fitting perfectly cells content.

Double-click any columns delimiters: each column is now readjusted perfectly.

Now, you know how to readjust, resize or stretch rows and columns in your Excel worksheet!

Become an expert in Spreadsheets by joining our Excel Certifying Course!

Advertising
Analytics

Categories

AllAdvertisingFormatsPlatformsKPI'sAd News
What is Programmatic Advertising?

What is Programmatic Advertising?

Understand what programmatic advertising is and how it works to increase your ROI and become a programmatic specialist.

Read More
Programmatic Advertising: What is a DSP?

What are DSPs?

A DSP is a great tool to use but what does DSP stand for in marketing? What are some Demand-Side Platforms examples? Today, we answer your questions!

Read More

Best DSPs for Programmatic Advertising

Ted Jordan shares his list of best DSPs for Programmatic Advertising so you don’t have to lose time searching the internet to find the right Demand-Side Platform for your campaigns.

Read More
Programmatic Advertising: What is a SSP?

Supply-Side Platforms (SSPs) Explained

SSPs basics in advertising: learn what Supply-Side Platforms are used for and who use them. Get familiar with more programmatic advertising technical terms.

Read More

What is O&O Advertising?

Discover one more important jargon term used in Programmatic Advertising: O&O advertising. Get familiar with O&O formats and advantages.

Read More
Programmatic: Pixels in Advertising 101

Advertising pixels: types, pros and best practices

Learn the basics of Programmatic Advertising with Ted Jordan! Today, we explain what a pixel is in advertising with simple words and expertise. Ready to learn?

Read More

Categories

AllFunctionsToolsShortcut Keys

How to change shapes in Excel column charts

Learn how to easily change the columns shape in your Excel charts so your colleagues and customers will remember your impacting graphs.

Read More

How to use the LEFT, RIGHT and MID functions

Learn how to extract text in Excel with the LEFT, RIGHT and MID functions. Plenty of examples to learn from and functions are explained with simple words. If you start...

Read More

Excel IF statement: how to use it for 3 conditions

Learn how to use the Excel IF statement with multiple conditions and combine it with OR and/or AND functions!

Read More
Navigating with Tab, Enter, and Shift Key on Excel.

How to move between cells when arrow keys are not working (Excel)

Learn how to move between Excel cells without using your mouse or arrow keys. Discover more shortcuts and tricks below!

Read More

How to use the IFERROR function (Excel + Google Sheets)

Discover how to use IFERROR in Excel or in Google Sheets in 4 easy steps! No more errors on your documents or dashboards with IFERROR.

Read More
Cope Paste Options on excel with shortcut keys

Copy paste values like a pro! (Excel+Google Sheets)

Copy and paste values (not formulas) using shortcut keys in Excel or Google Sheets! Learn how spreadsheets professionals do it within seconds and become one of them. Save time now...

Read More