How to copy column headers in Excel

Learn Microsoft Excel Online FreeMenuExcel HomeExcel BasicsExcel FunctionsExcel TemplatesExcel Pivot TableExcel ChartsExcel VBAExcel ExamplesExcel VLOOKUP Example600+ Basic Excel F

How to copy column headers in Excel

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.

Related Posts

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

Recent Posts

  • 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

©Copyright 2017-2022Excel How All Rights Reserved.|  Privacy Policy  |  Term Of Service  |  RSSx

Video liên quan