How to Convert\List Column Headers to Row Headers in Excel?

Sometimes we may have so many columns in one worksheet and user cannot view all column headers in one page due to width limit. In this case user has to drag the scrollbar to check the column headers which are located in the columns invisible in current page like column U, column V etc. Is there a convenient way to check column headers directly without drag the scrollbar? This article will help you to resolve this issue by convert column headers to row headers in excel.

Convert Column Headers to Row Headers in Excel


Prepare a table with 10 columns, and the column headers are column 1, column 2… till column 10.

Convert or List Column Headers into Rows 1

If you want to convert column headers into row headers by a quick way, you can use Paste Special function to implement our requirement. It can transpose a row to a column, in this case column headers saved in row1 can be transposed to specific column properly, and then user can check column headers quickly. Please follow below steps to implement it.

Step 1: Select the range you want to transpose from row to column. In this case if you want to only check the column headers in row for convenient you can only select A1 to J1.

Step 2: Click Ctrl+C to copy this row (the selected range).

Step 3: In A3 (or other cell you want to paste the column headers), right click to load menu.

Convert or List Column Headers into Rows 2

Step 4: In Paste Options, select Transpose (T) icon transpose icon to implement transpose.

Convert or List Column Headers into Rows 3

Step 5: Check the result. Verify that column headers are listed in one column properly.

Convert or List Column Headers into Rows 4

This is just a quick way to help you to view all column headers in one column by convenient; if you want all data transpose from row to column (or column to row), you can select all data range to do transpose.

 

Related Posts

Match Single Criteria in Excel

No repeat statistic based on a single condition is used wildly in daily work, for example, count type of products, the duplicate types are not encountered. This article describes the way of no repeats statistics for data in a single ...

Excel Array Construction

This article will talk about how to create one-dimensional array or two-dimensional array by using some functions in Excel. When using array formulas in Excel, we often use functions to construct arrays. Generate Array with ROW or COLUMN Functions Array ...

Excel Array Operation

We have all heard of arrays. Depending on the dimensionality, they are divided into one-dimensional arrays and two-dimensional arrays. Depending on the data type, they can also be divided into numeric arrays, logical arrays, and so on. The concatenation and ...

Excel Array Matrix Operation

In Excel, we have a built-in function used to perform matrix operations. It is the MMULT function. This function accepts two arrays as parameters and returns the product of the two arrays. However, this function has a prerequisite that the ...

A1 Reference Style and R1C2 Reference in Excel

In Excel, there are two reference styles. A1 reference style and R1C2 reference style. These two reference styles can help us find the cell by the cell address. Some functions return these two addresses through the argument settings. A1 Reference ...

Sidebar