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

“ROW HEIGHT” IS THE HEIGHT OF THE ROW PRESENT IN THE EXCEL. THERE ARE MANY WAYS TO ADJUST THE ROW HEIGHT. IT CAN BE AUTOADJUSTED OR IT CAN BE EXPLICITLY DECLARED.

THE DIFFERENT WAYS OF DOING THIS ARE GIVEN BELOW.

BUTTON LOCATION FOR ADJUSTMENT OF ROW WIDTH IN EXCEL

how to adjust row width in excel

HOW TO ADJUST ROW HEIGHT IN EXCEL?

SETTING FIXED HEIGHT OF ROW IN EXCEL

  • STEPS:

  • Select the cell/cells where the height 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.

SETTING AUTO HEIGHT OF ROW IN EXCEL

STEPS:

  • Select all the cell/cells where height 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 height of the content of all the selected rows.

HOW TO SET ROW HEIGHT MANUALLY IN EXCEL?

STEPS:

  • The ROW HEIGHT can be changed in excel using the mouse also.
  •  Select the row/rows where you want to change the height.
  • Just hold the boundary of any row and drag it as per 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.

ANIMATED EXAMPLE OF ADJUSTING ROW HEIGHT

how to adjust row height in excel

OTHER WAYS TO REACH THIS ARTICLE

  • ADJUST ROW HEIGHT, ANIMATED EXAMPLE OF ROW HEIGHT ADJUSTMENT, EXAMPLE OF ROW ADJUSTMENT, SET ROW WIDTH, STEPS TO SET ROW SIZE

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

gyankosh060309@gmail.com

Like this:

Like Loading...

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: