Course Content

Course Content

Adjusting Rows & Columns in MS Excel

How to Adjust Rows and Columns


No we will see that how we can adjust rows and columns into a particular size in MS Excel.

Suppose if we want to change the size of any three or four columns together, than we can select all the cells and can change the width of any one column and it will reflect in all of the selected columns.

To get any column into its best fit size we can just select that particular column and double click on it.

We can also individually change the width of the columns as per our requirement.

If by mistake we make any column very much small, then the data which us stored inside that will be converted to '###'.

Similarly we can also resize the size of rows.


The rows and columns can be adjusted in Excel. This is done by dragging the corners of the grid to resize it.

Columns are created by the "grid-template-columns" property and can have any number of columns. The default is 12 columns, but it can be adjusted to have more or less.

  • Excel allows you to freeze columns and rows.
  • Select the row beneath the one or more rows you want to freeze (select row 6, if you want to freeze rows 1 to 5).
  • Click Freeze Panes > Freeze Panes on the View tab.

The following are some of the advantages of adjusting rows and columns in MS Excel:

  • You can merge cells together to form one large cell.
  • You can move data from one row or column to another by dragging the cursor.
  • You can turn off or on certain rows or columns.
  • You can change the size of a column or row with just one click.

You're scrolling down your worksheet (or to the side), but a section of it has been stuck. This is most likely because you elected to freeze the panes at some point. Unfreeze Panes under View > Window > Unfreeze Panes to remedy this.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere