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


How to Align Text Vertically in WPS Office [Easy Way]

October 2, 2023

WPS Office is a suite of software that is similar to Microsoft Office. It has a wide range of features, including the ability to vertically align text. However, some users may not know how to do this. This article will introduce a guide on how to vertically align text in WPS Office.

Part 1. How to Align Text Vertically in WPS Office?

WPS Spreadsheet

Step 1: Open the Excel sheet where vertical text alignment is needed.

Step 2: After entering text, right-click the cell.

Step 3: Choose "Format Cells" from the drop-down list.

Step 4: In the Format Cells dialog, go to the Alignment tab.

Step 5: Check the "Vertical text" box to display characters vertically.

WPS Writer

Step 1: Select the text you want to change.

Step 2: Use the "Text Direction" feature in the Page Layout tab.

Step 3: Make it vertical from left to right or right to left.

Access this feature by clicking the "Text Direction Options" button in the Text Direction drop-down list to preview the text rotation effects.

WPS Presentation

Step 1: Click the text to access the Text Tools tab.

Step 2: Click the "Text Direction" drop-down button.

Step 3: Select "Vertical." Vertical from left to right or right to left.

Part 2. How to Rotate Text Vertically in WPS Office?


Step 1: Enter the text content you want to rotate in the cell.

Step 2: Right-click and select the "Format Cells" option from the shortcut menu.

Step 3: In the pop-up dialog box, navigate to the Alignment tab.

Step 4: In the Orientation area, set the degrees of rotation as needed.

Step 5: Finally, click the OK button to apply the rotation.

WPS Writer

Step 1: Open your document using WPS Office.

Step 2: Click the Page Layout tab, then choose the Text Direction button.

Step 3: Select the desired text direction, such as "Rotate All Text 90°," "Rotate All Text 270°," or "Rotate Asian Characters 270°."

Step 4: You can also click the "Text Direction Options" to preview the text rotation effects.

WPS Presentation

Step 1: Select the text in the text box.

Step 2: Use the Text Direction feature found in the Home tab.

Step 3: This allows you to rotate the text by 90°, 270



WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User


Algirdas Jasaitis

Part 3. How to Center Text in WPS Office?

Let's take WPS Writer as an example:

Step 1: Open your document using WPS Writer.

Step 2: Select the text you want to center within the document.

Step 3: Navigate to the Home tab.

Step 4: Click the "Center" button in the toolbar. This will instantly center the selected text or you can simply press Ctrl + E

Part 4. Why Use WPS Office?

WPS Office is a great choice for anyone who wants to have an efficient and comfortable working experience with office software. Here are some reasons why you should use WPS Office:

  • Compatibility: WPS Office is fully compatible with Microsoft Office files, ensuring you can effortlessly work with colleagues and clients who use different office software.

  • Feature-Rich: Enjoy a comprehensive suite that includes powerful tools like Word Processor, Spreadsheet, and Presentation, mirroring the features of PowerPoint, Word, and Excel. Create, edit, and collaborate with ease.

  • Efficiency: Utilize AI-driven tools for paper writing, translation, and data visualization. WPS Office streamlines tasks, making your work more efficient.

  • PDF Handling: Seamlessly view, edit, generate PDFs, and annotate forms within the same interface, eliminating the need for additional software.

  • Cloud Storage: Store your files securely online, granting you easy access and enabling seamless sharing from any location.

These are some of the benefits of using WPS Office. If you want to try it out, you can download it for free from official website


1. How to change the vertical text to horizontal in WPS Writer?

To change vertical text to horizontal in WPS Writer, go to the Page Layout tab, click the Text Direction button, and select "Horizontal Text Box" from the options. This straightforward process makes it easy to switch the text orientation for improved readability and editing.

2. How to Change horizontal data to Vertical in WPS Spreadsheet?

For a full column or range, use this function: Enter =TRANSPOSE(A1:A10) into a blank cell, where A1:A10 represents the range of cells containing text in rows.

If you want to transpose only specific cells, click on the cell you want to start with, drag the cursor across the range of cells to be transposed. The result will appear in another cell at the same position where you started the selection.


In conclusion, this guide has equipped users with essential skills for text alignment, rotation, and centering in WPS Office. It covers vertical text alignment in Spreadsheet, Writer, and Presentation, providing clear instructions for flexible document formatting.

Furthermore, WPS Office shines as an excellent choice for those seeking a smooth and efficient office software experience. It seamlessly integrates with Microsoft Office files and offers a feature-rich suite, including Word Processor, Spreadsheet, and Presentation tools. Plus, the infusion of AI-powered features elevates your productivity, while the seamless handling of PDFs and secure cloud storage add to its appeal..

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