Spacing rows and columns in Excel beautifully
Spacing rows and columns in Excel beautifully Picture 1
When editing text in Excel, you will come across cases where rows or columns of unequal width make your text look bad. After editing, we need to readjust the text to be more even and beautiful. If we had to adjust each column individually, it would be very time-consuming and it was difficult for the calibration to not deviate an inch.
Today, Thuthuatphanmem.vn would like to guide a few tips to help you align rows and columns in Excel.
Spacing rows and columns in Excel beautifully Picture 2
1. Align the row and column to fit the data in the cell
Method 1:
You highlight all the columns you need to align by hovering over the first column name position and clicking and dragging to the last column.
Then move the mouse cursor to the line position between the two rows or columns and double click. Excel automatically adjusts your rows and columns to fit the data in the cell.
Spacing rows and columns in Excel beautifully Picture 3
Method 2:
You highlight the area to be aligned. Go to the Home tab , look in the Cells section for the Format icon .
- Select AutoFit Row Height if you want to automatically align the line to the data.
- Select AutoFit Column Width if you want to automatically align the column to the data.
Spacing rows and columns in Excel beautifully Picture 4
The result you get when doing the above two ways is an array of data with columns and rows that fit the data as shown below:
Spacing rows and columns in Excel beautifully Picture 5
2. Stretch lines and columns to get the same length
Highlight the column or line that needs alignment as shown above.
Spacing rows and columns in Excel beautifully Picture 6
Method 1:
Move the mouse to the line between two columns or rows, then click and drag and stretch or shrink as you like.
Note: You should choose the line between the first column (row) and the second column (row) to be able to clearly estimate the width after alignment.
Spacing rows and columns in Excel beautifully Picture 7
Method 2:
Go to the Home tab , look in the Cells section for the Format icon .
- Select Row Height if you want to align the line.
- Select Column Width if you want to align the column.
Spacing rows and columns in Excel beautifully Picture 8
A small window will appear, enter the number of spaces you want to stretch evenly in the Row height box .
Spacing rows and columns in Excel beautifully Picture 9
After doing either of the above, you will get results of columns or rows of equal size as shown below:
Spacing rows and columns in Excel beautifully Picture 10
Thank you for following the article on how to create lines and columns of Thuthuatphanmem.vn , wish you successful implementation.
You should read it
- How to convert columns into rows and rows into columns in Excel
- How to move rows and columns in Excel
- MS Excel 2007 - Lesson 10: Modify columns, rows and cells
- How to handle cells, columns, rows in a spreadsheet in Excel
- Complete tutorial of Excel 2016 (Part 6): Change the size of columns, rows and cells
- How to quickly Add and Delete rows and columns in Excel
- How to temporarily hide rows and columns in Excel 2013
- How to add rows and columns in Excel
- How to fix column and header rows in Excel 2016
- How to convert rows into columns and vice versa in Excel
- How to add columns, delete columns, add rows, delete rows in Word 2007, 2010, 2013, 2016
- Excel does not allow inserting additional columns and rows [FIXED]
May be interested
Beautiful applause images for Powerpoint
The most beautiful historical Powerpoint wallpapers
Powerpoint Thank You wallpapers, Thanks for the Slide ends
The most beautiful and impressive opening Powerpoint wallpapers
50+ funniest, cutest Powerpoint wallpapers
The most beautiful green Powerpoint wallpapers