0
You transpose the data. First copy your data as normal. Then move to the first cell of where you want the data to be pasted. Then, instead of picking Paste, pick Paste special. Tick the Transpose box and click OK. The data will be pasted, but changing the orientation when it does so. There is also a function called TRANSPOSE which is an Array function which can do a similar thing.
What else can I help you with?
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.
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.
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.
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
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.
What are the horizontal lines in Excel called?
Rows and Columns and the "boxes" are called cells
What is vertical and what is horizontal?
Vertical is up and horizontal is across
What is an excel worksheet The worksheet is a organized rectangular grid containing vertical columns and horizontal rows?
OK. You answered your own question.
Is the san Andreas fault horizontal or vertical?
Vertical and horizontal
What type of power sharing does India have horizontal or vertical?
vertical and horizontal
