How To Make Text Vertical In Excel- C ell Formatting method? The result will be shown in another cell at the same position as where you pulled your cursor from.Īs you can see, it has converted horizontal text into vertical now you know how to make text vertical in Excel. If you want to change only some cells, click on the cell you wish to affect and drag the cursor across the range of cells you want to transpose. Here A1:A10 represents the range of cells that contain text in rows.Ģ. To use this function, enter = TRANSPOSE( A1:A10) into a blank cell. You can use this function to change the orientation of your data from horizontal to vertical.ġ. The transpose function changes the rows of your data into columns and vice versa.

How To Make Text Vertical In Excel-Using Transpose Function? Tips that are provided in this article are compatible with versions 2010/2013/2016. It's helpful when you want to present your data abruptly. This tutorial will show you how to make text vertical in Excel. For this purpose, we can use the Vertical Alignment feature of Excel, which helps us rotate the cells/text from Horizontal Type to Vertical Type. This is because of security reasons, tabular forms, etc. In some worksheets, it is required to display texts like a report or a column vertically. Do you have lists of information that you need to fit in a spreadsheet? Are you tired of having to scroll down the page to view more details ? Would you like the ability to type out lists on a single line so that they take up less space on the page while still being easily readable? Being able to make text vertical in Excel can be very useful.

How to angle text in excel 2013