PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
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.
In this article we would learn to use the different ways to adjust the row height to our requirement.
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 .
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:
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:
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:
YOU MAY LIKE