PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO ADJUST ROW HEIGHT IN EXCEL?

INTRODUCTION

Rows and columns are the building blocks of any spreadsheet application which makes it mandatory to learn the ways to edit the physical size of the cell which can be a requirement frequently.

“ROW HEIGHT” IS THE HEIGHT OF THE ROW PRESENT IN THE EXCEL SHEET. THERE ARE MANY WAYS TO ADJUST THE ROW HEIGHT.

 
THE ROW HEIGHT NEEDS TO BE ADJUSTED IF WE HAVE DIFFERENT KIND OF DATA, OR TO MAINTAIN THE UNIFORMITY OR ANY OTHER REASON.
 

In this article we would learn to use the different ways to adjust the row height to our requirement.

 

 

 

BUTTON LOCATION FOR ADJUSTMENT OF ROW WIDTH IN EXCEL

The option or button for the ROW WIDTH is present under the HOME TAB  and FORMAT DROP DOWN under the CELL SECTION.

The location of the button is shown in the picture below .

how to adjust row width in excel
BUTTON LOCATION OF ROW WIDTH ADJUSTMENT

SET FIXED ROW HEIGHT IN YOUR SHEET IN EXCEL

This option fixes the height of the row as specified by the user.

But before that we need to know about the height scale.

The scale is point based. The complete width is 409 and the default is 15.

Type

Min

Max

Default

    

Row

0 (hidden)

409

15.00

For example, if you want the height to be greater than the standard, select it to be more than 15.00, otherwise lesser.

STEPS:

  • Select the cell or cells or row or rows where the width is to be changed.
  • Go to HOME>CELLS>FORMAT and click ROW HEIGHT.
  •  In the dialog box, enter the HEIGHT as per requirement in pixels.
If you enter 409, it’ll create a cell equal to the full screen width and the size will reduce proportionately as per the row height entered.
HOW TO ADJUST ROW WIDTH IN EXCEL
EXAMPLE SHOWING SETTING OF CUSTOM ROW WIDTH

SET AUTO HEIGHT OF ROWS IN EXCEL

If we have a situation where we have different size of data in all the ROWS and we need the row height just fine to show all the data, we can use this option of fixing the auto height of the rows.

USE THIS OPTION IF YOU NEED TO SET THE HEIGHT OF EACH ROW EQUAL TO THE HEIGHT OF THE CONTENT [ BIGGEST FONT SIZE ].

STEPS:

  • Select all the cell or cells or row or rows  where WIDTH needs to be changed.
  • Open the option under tab HOME>CELLS>FORMAT.
  • CLICK AUTOFIT ROW HEIGHT.
  • The height of the rows will be adjusted according to the font size of the content to make it visible.
HOW TO ADJUST ROW WIDTH IN EXCEL
EXAPMLE SHOWING THE AUTOFIT ROW HEIGHT ADJUSTMENT

MANUALLY SET THE HEIGHT OF ROWS IN EXCEL

If you feel a bit lethargic in going to the Custom height or Auto fit row height options, there is a manual option too which is quite fast to use.

THIS IS THE FASTEST METHOD BUT USEFUL IF WE WANT TO WORK ON A SINGLE OR A BIG NUMBER OR ALL THE ROWS AT THE SAME TIME . WE MAKE USE OF THE MOUSE WHILE ADJUSTING THE ROWS HEIGHT IN THIS METHOD

STEPS TO BE FOLLOWED:

  • Select the row or rows where you want to change the height.
  • Just hold the boundary of any of the selected row and drag it as per the required height.
  • If, more than one rows are selected, all selected rows will get the same height as fixed manually using the mouse of any of the selected rows.
  • If a single row is selected, only the selected row will get the new height.
HOW TO ADJUST ROW WIDTH IN EXCEL
EXAMPLE SHOWING THE MANUAL ADJUSTMENT OF ROW HEIGHT

Leave a Reply

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

KINDLY SPEND FEW SECONDS HERE....

-We might be compensated for the visits or purchases you make by clicking the ads on this website .  They help us to keep bringing excellent quality articles for you.
-Click on the pictures if you can’t read. All of them are High Resolution .
-If you can’t find what you were looking for, kindly message in the chat box.
*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW