Adjust the rows/columns in excel sheet to fit cell content

  1. Click the Select All button. or click an unused cell outside the range of data and press Ctrl + A. The entire sheet will become grey (highlighted).

2. Next hover between the columns or rows as needed until the line with arrow on both sides appears (picture below). Then double click to AutoFit the columns to fit the cell content.

Another way is as follows

1. Click the Select All Button.

2. Click on the Format Button and select AutoFit Row Height or AutoFit Column Width.

Sign up to discover human stories that deepen your understanding of the world.

Free

Distraction-free reading. No ads.

Organize your knowledge with lists and highlights.

Tell your story. Find your audience.

Membership

Read member-only stories

Support writers you read most

Earn money for your writing

Listen to audio narrations

Read offline with the Medium app

Beanstalk CFO Group
Beanstalk CFO Group

Written by Beanstalk CFO Group

Our firm, Beanstalk CFO Group, delivers financial management & advice to small business owners.

No responses yet

Write a response