How to convert a column into a row in excel 2016





Posted By nikki
List ViewGrid View

This guide is part of the Microsoft Excel 2016 series



Make: Microsoft

Model / Product: Excel

Version: 2016

Objective / Info: Learn to convert a column into a row in Excel 2016.


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 Columns

Ask a question or provide an answer

Posted Q&A(0)


Name
Email
URL
Comment