Buzz
When composing text in Excel, encountering uneven row or column widths can make your document look messy. After composing, aligning them becomes necessary for a neat appearance. Aligning each column and row individually can be time-consuming and challenging to align perfectly.
Today, Mytour provides guidance on how to align rows and columns in Excel.
1. Aligning Rows and Columns Snugly with Cell Data
Method 1:
To align the columns you need, select them by hovering over the first column name, then click and drag to the last column.
Then move the mouse pointer to the line between two rows or columns and double-click. Excel will automatically adjust your rows and columns to fit the data in the cells.
Method 2:
Select the area you want to align. In the Home
- Choose AutoFit Row Height if you want to automatically align the row to fit the data.
- Choose AutoFit Column Width if you want to automatically align the column to fit the data.
The result you get when using these two methods is a dataset with columns and rows fitting snugly around the data as shown below:
2. Equalize Row and Column Lengths
Select the column or row you want to align as instructed above.
Method 1:
Hover between two columns or rows, then click, hold, and drag to expand or shrink to your desired size.
Note: It's recommended to select the line between the first and second columns to accurately estimate the width after alignment.
Method 2:
Navigate to the Home tab, look under Cells section for the Format icon.
- Choose Row Height if you want to align rows.
- Select Column Width if you want to adjust columns.
A small window will appear, enter the desired spacing into the empty Row height field.
After performing either of the above methods, you will have columns or rows with equal sizes as shown below:
Thank you for following the tutorial on how to stretch rows and columns by Mytour, wishing you success.
