How to convert a column into a row in excel 2013





Posted By nikki
List ViewGrid View

This guide is part of the Microsoft Excel 2013 series



Make: Microsoft

Model / Product: Excel

Version: 2013

Objective / Info: Learn to convert a column into a row in excel 2013.


1
Open excel by double left clicking the icon on the desktop or start menu.

2
Select the cells that you want to convert.

3
Right click and copy the cells.

4
Select the column where you want to display the set of data

5
Right click on the cell and select the "Paste Special" option.
6
Select the "Transpose" box and click the "Ok" button.
7
The data should convert paste into a set of columns horizontally.
  Note : You can remove the data in the rows by pressing the "delete" key on the keyboard while the rows are still selected.

8
This task should be complete. If it is not, review and repeat the steps.

|






comments powered by Disqus

Tag : Convert a Column

Ask a question or provide an answer

Posted Q&A(0)


Name
Email
URL
Comment