Working with Microsoft excel is working with columns. We can easily adjust the column width in Microsoft Excel so that the columns can be neatly arranged. For example, by setting the same column width, and or the like.
Table of Contents
Easy Ways to Adjust Column Width in Excel
Below is a trick on how to adjust column width easily and quickly. How to? Follow the guide below.
Set Column Width
When we use Microsoft Excel 2016, the data we enter is often not enough in the cell concerned, this is possible by the length of the data, the size of the font or others.
Change Column Width To A Specific Width
Adjusting column width and row height can actually be done manually, namely by taking a line (Press the right mouse button) then dragging it according to the column width or row height that we want. However, if we want to arrange a large number of columns and rows and want the same size then we can do the following steps:
- Select the column or row that we want to adjust
- Select Home Tab> Format> Column Width for column size or Row Height for row height.
- Enter the number in the column width according to our wishes, for example 20
- Click OK
That's how to easily and quickly set or adjust column width in Microsoft Excel.
If you have questions, or other tricks related to how to adjust column width and row height in Microsoft Excel, please write in the comments column below. May be useful