Learn Microsoft Excel Online FreeMenu
- Excel Home
- Excel Basics
- Excel Functions
- Excel Templates
- Excel Pivot Table
- Excel Charts
- Excel VBA
- Excel Examples
- Excel VLOOKUP Example
- 600+ Basic Excel Formulas & Functions with Examples
- Google Sheets
- Google Sheets Functions
- Google Sheets Templates
- Contact Us
How to Convert\List Column Headers to Row Headers in Excel?scott[emailprotected]February 21, 2020Excel Examples
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.
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.
Step 4: In Paste Options, select Transpose (T) icon
to implement transpose.
Step 5: Check the result. Verify that column headers are listed in one column properly.
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.
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 ...Excel Structure Reference
This tutorial introduces the basics of structured referencing in Excel and shows you how to use structured referencing in a table with examples. When you use formulas that reference tables, whether the formula references a part of the table or ...Excel/Google Sheets: Full Row Reference
Excel or Google sheets supports both full row references and full column references. This article will talk about the usage of full row references. Full Row reference is another cell reference in Excel or Google Sheets, which is used to ...Excel/Google Sheets: Full Column Reference
Full column reference is another cell reference in Excel or Google Sheets, which is used to reference the entire column, for example, if you want to reference the entire column A, you can use the following reference format A: A. ...Excel/Google Sheets: Expanding Reference
An expanding reference is a reference type in Excel and Google worksheets that extends the range of a cell when a formula is copied to the cell below or to the right. In this article, we will explain how to ...
Other postsHow to Print a Table without Color Filled in Cells in Excel «» How to Calculate Average among Multiple Different Worksheets in ExcelSidebar
- A1 Reference Style and R1C2 Reference in Excel
- Excel Structure Reference
- Excel/Google Sheets: Full Row Reference
- Excel/Google Sheets: Full Column Reference
- Excel/Google Sheets: Expanding Reference
- Excel/Google Sheets: Mixed Reference
- Excel/Google Sheets: Absolute Reference
- Excel/Google Sheets: Relative Reference
- Conditional formatting based on another column in Google Sheets or Excel
- Conditional Formatting based on Another Cell in Google Sheets/Excel