answersLogoWhite

0


Best Answer

Copy the table. Go to a clear part of the worksheet. Then go to Paste Special and click Transpose and then OK. You can also use the TRANSPOSE function.

User Avatar

Wiki User

9y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

14y ago

You can change the formatting of the text in the alignment options, which are in the Format menu, under Cells.

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

Columns are vertical arrangements of cells in Excel.

This answer is:
User Avatar

User Avatar

Wiki User

9y ago

Press Ctrl - 1 to get to the Format Cells dialog box. In the Alignment tab, you can use the Orientation settings to adjust the direction that text is going.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you convert horizontal data to vertical format in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

You can include horizontal gridlines on a form but not vertical gridlines?

You can create a form with MS Excel that has both horizontal and vertical gridlines, you just format the borders of the cells you want to display.


Vertical columns and horizontal rows?

Columns are always vertical and rows are always horizontal. Together they form a table. These appear in different applications, such Word, Access and Excel. In Excel they are known as a worksheet.


How do you Convert Tally 7.2 xml data into Excel Format?

tally 7.2 data convert into excel


On an Excel spreadsheet what is in the column spaced horizontally?

Columns are vertical, rows are horizontal.


Horizontal bar going across the middle of a window in excel?

Vertical Split Bar


Verical lines in Microsoft Excel are called in microsoft EXcel?

The actual lines are known as gridlines, both vertical and horizontal. A vertical line of cells is known as a row.


How can I convert PDF to excel for free?

Well, I would recommend converting PDF format files to excel format files with a PDF format file to excel format file converter. There are many PDF format file to excel format file converters offered for use.


What are the 7 horizontal cell alignments in Microsoft Excel?

There are seven cell alignments in Excel, but not all are horizontal. 4 x HORIZONTAL: left, center, right, full 3 x VERTICAL: top, center, bottom


How do you convert Excel files to a different format?

It depends on the format you want. Excel can not be converted to every conceivable file type. However, you have many choices through the Excel "Save As" option.


How do you convert windows Excel 7 to windows Excel 97-2003 version?

Open the workbook in Excel 7 and SaveAs the format you want.


What are the horizontal and vertical lines in a chart that enable the eye to follow the value on an axis in Excel called?

Grid lines.


How are vertical and horizontal alignment done in Excel?

Horizontal alignment is the positioning of content in the cell across, like to the left, right or centre. Vertical alignment is the position of the content from the top of the cell to the bottom of a cell. If a cell is increased in height over its usual setting, then the vertical alignment can be used to position content at the top, middle or bottom of a cell. Both vertical and horizontal alignment can be done on the Alignment tab in the Format Cells dialog box. Pressing Ctrl-1 will open it.