The use of special software products for working with tables and various databases makes it much easier for users to work with certain arrays of information. The most popular at present is the use of Microsoft Excel. It allows you to quickly and easily work with tables.
The specified program has quite flexible options for setting up and editing the format for displaying data in rows and columns. Using the functions of automatic selection of cell parameters allows you to fix the appearance of the table in just two steps.
What is row height in Microsoft Excel
Tables in Microsoft Excel (MS Excel) are a collection of cells that have certain parameters. By default, they are 12.75 pixels high to accommodate visible text written on a single line. In cases where the line wrapping function is enabled for the table, the column height will automatically increase if the text placed in the cell is sufficientvoluminous.
However, this software has several options to help the user set the parameters as they wish.
How can I set the line height
There are times when a user, for aesthetic reasons, wants all cells in a table to have the same height. This formatting is often used for not too bulky tables that contain a small amount of text.
The desired parameter can be set using the "Line Height" function, which is located in the menu item: "Format". In this case, all lines selected in advance will have a manually set parameter. Simultaneously with the above function, users often resort to manual selection of cell height. To do this, press the left mouse button on the bottom border of the cell and drag the cursor in the desired direction. If you need to change the height of several lines at once, then first select them, and then select the required line height using the cursor.
The methods described above for adjusting cell parameters are rarely used. Users are more actively using the MS Excel "AutoFit Row Height" function, the details of which will be described below.
Note that there are three easy ways to change the line height:
- Set the parameters by specifying the exact height using the MS Excel "Row Height" function.
- Manually stretch line height using mouse cursor.
- Use in MS Excel"Auto-fit line height".
The third way is the fastest and most convenient. It allows you to customize the appearance of the table so that all the text entered in it is displayed.
What the table looks like before using autofit, for what reasons it may be needed
Suppose a user has created a table, some cells of which contain rather large text. However, the author does not have the ability to use wide columns, since the table will not fit on a landscape sheet when printed. That is, the text entered by the user in the cells is not displayed in full (as in the figure below).
In this case, before starting the process of formatting cells using the autofit column width and row height method in Excel, you should enable the option to transfer them. This is very easy to do.
How to do automatic line wrapping
To use this function, you must first select the part of the table for which you want to apply word wrapping (the easiest way to select the desired cells is to hold down the left mouse button and drag it in the specified direction). Then, in the "Format" menu section, select the "Format Cells" item, in the window that appears, go to the "Alignment" tab.
In it, in a special box, put a tick in front of the phrase "Wrap by words" and click the "OK" button. As a result of the above actions, the text in allselected cells will be word-wrapped, and the edited table will look similar to the one you see in the photo below. That is, the height of some lines will increase exactly as much as necessary in order to display all the text entered in the cells.
As you can see, MS Excel did its own autofitting of row heights in this case. The user did not need to perform any additional actions. This happens if a person does not change the height of the lines themselves before using the "Word Wrap" option. That is, the height was set by the program by default.
If Excel's auto-fit row height does not work automatically, the user should follow a few simple steps.
How to auto-fit the line height yourself
To quickly and easily bring the created table into the proper form, select the necessary cells or the entire table. Then in the menu item "Formatting" you need to select the item in Excel "Autofit row height". How to do this in practice is shown in the photo below.
After this action is completed, the table format will become easy to read, and all the text entered in the cells will be displayed correctly, as in the next photo.
When it is impossible to auto-fit the line height
There are times when the above steps do not helpmake the required changes to the parameters of the table rows. How to auto-fit row height in Excel if none of the tips suggested in the article helps, and the user does not understand why automatic formatting does not work correctly? This is due in most cases to the fact that a person combined some cells with each other.
If there are overlapped cells in the table, autofitting of row heights will not work for them. The user will have to set the appropriate parameter for them manually. In this case, you must use the function of setting the exact height of the line or manually stretch it using the cursor.
The auto-fit row height feature in Excel 2010 is quite popular among users, as it allows you to quickly bring the table to a convenient form that will be easy for visual perception.