How to align rows and columns evenly in a sheet: Simple and easy steps

You see that the data in the spreadsheet in Google Sheet is not aligned but you don’t know how to align it to make it look nice and professional. Don’t worry, FPT Shop will guide you through 4 simple and quick ways to align rows in the sheet.

Why do you have to align rows in Sheet?

After creating a table in Google Sheet and entering data, you need to perform alignment. It is possible that the data inside the cells is too long compared to the cell size or the data is too short while the cell is too large.

This creates an imbalance that makes the spreadsheet look unattractive. For important documents or company documents, you will be judged as lacking professionalism and basic office computer skills.

If you don’t know how to align rows in a sheet, let’s add this knowledge right away.

Simple ways to align rows in Sheet

How to automatically align rows in a sheet evenly

If the rows in the sheet have different sizes and you want to align them to the same size, do the following:

Step 1: Open Google Sheet and select the sheet you want to align the rows, then select the entire data range.

Step 2: Place the mouse pointer over the dividing line between two consecutive rows until it becomes a two-way arrow or parallel lines (as shown below).

Step 3: Drag the mouse down to increase the row width or drag it up to narrow the row. Release your hand when the row has the appropriate size.

The result is that all rows have the same width.

How to automatically align columns in a sheet evenly

Similarly, you can adjust the size to make all columns in the sheet automatically align evenly by following these steps:

Step 1: Select the entire data range in Google Sheet.

Step 2: Place the mouse pointer over the dividing line between two consecutive columns until it becomes a two-way arrow or parallel lines as shown below.

Step 3: Drag the mouse to the left to decrease the column width or drag it to the right to increase the column width. Release your hand when it’s just right.

The result is that all columns have equal width:

How to adjust the row width according to the data

In case you want to adjust the row width to fit the data inside, follow these 3 steps:

Step 1: Select the rows to be adjusted by clicking the number cell of the row.

Step 2: Right-click anywhere in the selected data and then choose Resize row.

Step 3: A dialog box appears, you check the Fit to data box and click OK to apply.

The result is as follows:

How to adjust the column width according to the data

Similarly, if you want to adjust the column width to fit the data inside, do the following:

Step 1: Select the columns to be adjusted.

Step 2: Right-click anywhere in the selected range and then click Resize column.

Step 3: A dialog box appears, you check Fit to data and click OK to apply.

The result is that the column width fits the data inside as follows:

Conclusion

So through this article, FPT Shop has instructed you on how to align rows in a sheet. At the same time, you can also apply it to columns to make your spreadsheet look even, nice and professional.