WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


Set the cell alignment

Uploaded time: February 21, 2022 Difficulty Beginner

Set the cell alignment

Set the cell alignment

In order to ensure the aesthetics of the table, sometimes, we need to adjust the text alignment within the table.

Take this table as an example.

Go to the Edit mode, and open Tools. In the Home tab, we can find the Align Text ribbon. Here, we can select nine types of textalignment.

They are: Top Left Align,Top Center Align, Top Right Align,Middle Left Align,Center Align,Middle Right Align, Bottom Left Align, Bottom Align and Bottom Right Alignrespectively.

We can choose the different alignments according to our needs.

If we need to change the text alignment in bulk, we can simply select the cells' range and corresponding alignment.We choose Centerhere.

In WPS Office for PC, Align Text is more versatile and easy to operate.

In addition to the nine types of alignment described above, we can also set the text Justify, Distributed, and so on in WPS Office for PC. Furthermore, we can adjust the spacing between cell borders and text.Please feel free to use Align Text in WPS Office for PC.

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.