How to center vertical text in excel

This Excel tutorial explains how to center text across multiple cells in Excel with screenshots and step-by-step information.

First, we will center text through the excel tools. It requires some steps to follow.

1) The first step is to make data in a spreadsheet. The data for example which we include here is students’ name and their IDs.

2) The second step is to click on the HOME button which appears on the top of the spreadsheet and when you click on several options will show under this HOME. You find a line-type option below the formula and here there is a central text.

3) Our third step is to click on the text which you want to select to do the center text. And then click on the above option like this your data will become center text.

By these following steps, you can easily understand how to center text in excel.

How to center text in excel through another method.

This function also performs the same as above but there are some differences between the above one and this one. To solve this method, we need to perform some steps which are given below.

1) The first step is to make data in a spreadsheet on which we like to perform this function. Here for this method, I again get students’ names and student IDs as an example.

2) After that select the text or cells on which you want to do center text and press the right click of a mouse, a dialog box will appear and you find several options in it. Click on the align box and here you again find several options like in which type you want to align your selected text, whether on left, right, or in the center.

3) After clicking on align center your selected text or cell will align in the center like this.

Congratulations, you again find out how to center text in excel by following all these steps without any hassle.

How to center text in excel through the Format cell method.

This is the third step by which we can easily find how to center text in excel. This function also needs step-by-step instructions to follow.

1) The first step is to make data in a spreadsheet as above and take the same example of student names and student ids.

2) The second step is to imply the format cells function to find out how to center text in excel. Select the text or cell in which you like to be text in the center and then press the right click on a mouse and you will find many options press on format cells, a dialog box will appear after this like this.

3) Last step is to click on horizontal center and vertical center and then press OK, your selected data will be in a center.

Congratulations you again find out how to center text in excel with the format cells method by following all this steps by step information.

You can also find this feature in the latest excel versions 2016/2018/2019 spreadsheet, where you can easily find how to center text in excel.

Did you learn how to find how to center text in excel.? You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets, and PowerPoint Slides.

You can also download WPS Office to edit word documents, excel, and PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience