EDUCBA

EDUCBA

MENUMENU
  • Blog
  • All Courses
  • All in One Bundle
  • Login
Home Excel Excel Resources Excel Tips Column Header in Excel

Column Header in Excel

By Madhuri ThakurMadhuri Thakur

Column Header in Excel

Introduction to Column Header in Excel

Column Header is a very important part of Excel as we work on different types of Excel tables daily. Column Headers tell us the category of the data in that column to which it belongs. For example, if column A contains the Date, then the Column header for Column A will be “Date”, or suppose column B contains the Names of the student, then the column header for Column B will be “Student Name”. Column Headers are important when a new person looks at your Excel. He can understand the meaning of the data in those columns. It is also important because you must remember how your Excel data has been organized. So from the data organization standpoint, Column Headers play a very important role.

There are many ways of creating headers in Excel. The three best possible ways of creating headers are below. This article will look at the best ways to organize or format the column headers in Excel.

  1. Freezing Row/Column.
  2. Printing a header row.
  3. Creating a header in Table.

We will look at each way of creating a header one by one with the help of examples.

Suppose you are working on the data with many rows, and when you scroll down in the worksheet to look at some data, you may not be able to look at the Column Header. This is where Freeze Panes helps in Excel. You can scroll down in the Excel sheet without losing visibility to the column headers.

How to Use Column Headers in Excel?

Column Header in Excel is very simple and easy. Let’s use the column Header in Excel with some examples.

You can download this Column Header Excel Template here – Column Header Excel Template

Example #1 – Freezing Row/Column

  • Suppose there is data related to customers in Excel, as shown in the below screenshot.

column header in excel example 1-1

  • Use the SUM formula in cell D19.

column header in excel example 1-2

  • After using the SUM formula, the output is shown below.

column header in excel example 1-3

  • The same formula is used in cell E19 and cell F19.

column header in excel example 1-4

You need to follow the below steps to freeze the top row.

  • Go to the View tab in Excel.

column header in excel example 1-5

  • Click on the Freeze Pane Option

column header in excel example 1-6

  • You will see three options after clicking on the Freeze Pane option. You need to select the “Freeze Top Row” option.

column header in excel example 1-7

  • Once you click on the “Freeze Top Row”, the top row will be freezer, and you scroll down in Excel without losing visibility to Excel. You can see in the below screenshot that Row 1, which has column headers, are still visible even when you scroll down.

column header in excel example 1-8

Example #2 – Printing a Header Row

When you work on large spreadsheets where data is spread across multiple pages and when you need to take a printout, it doesn’t fit well on one page. The printing job becomes frustrating as you cannot see the column headers in print after the first page. In that scenario, Excel has a functionality known as “Print Titles”, which helps set a row or rows to print at the top of every page. We will take a similar example which we have taken in Example 1.

Follow the below steps to use this functionality in Excel.

  • Go to the Page Layout tab in Excel.

column in example 2-1

  • Click on Print Titles.

column in example 2-2

  • After clicking on the Print Titles option, you will see the below window open for Page Set up in Excel.

column in example 2-3

  • In the Page Set up window, you will find different options that you can choose.

(a) Print Area

  • To select Print Area, click on the button on the right side, as shown in the screenshot.

column in example 2-4

  • After clicking on the button, the navigation window will open. You can select from Row 1 to Row 10 to print the first 10 rows.

column in example 2-5

  • If you want to print Row 11 to Row 20, select the Print Area from Row 11 to Row 20.

column in example 2-6

  • Under Print Titles, you can find two options.

(b) Rows to Repeat at Top

This is where we need to select the column header, which we want to repeat on every printout page. To select Rows to repeat at the top, click on the button on the right side, as shown in the screenshot.

column example 2-7

After clicking on the button, the navigation window will open. You can select Row 1, as shown in the below screenshot.

column in example 2-7

(C) Columns to Repeat at Left

You want to see this column on the left, which will repeat on every page. We will keep it as blank as we don’t have any row headers in our table.

  • Now click on the “Print Preview” option on the page setup as shown in the below screenshot to see the Print Preview. As you can see in the below screenshot, the print area is from Row 11 to Row 20, with the column headers in Row 1.

column in example 2-8

  • Click on Ok in the Page setup window after exiting from Print Preview.

column example 2-9

Example #3 – Creating a Header in a Table

One of the features of Excel is that you can convert your data into a Table. It automatically creates Headers when you convert your data into a table. But please note that these headers are different from the Worksheet column heading or printed headers, which we have seen earlier.

  • We will take a similar example that we have taken earlier.

example column 3-1

  • Click on the “Insert” tab and then the “Table” button.

column example 3-2

  • After clicking on the “Table” option, you can give the range of data you want to convert into the table and select the “My Table has Headers” checkbox, as shown in the screenshot below. The first row of your selection will automatically be assigned as column headers.

column example 3-3

  • Click Ok. You will see your data is converted into a Table.

column example 3-4

  • You can Enable or Disable the Header row by going into the “Design” tab of the Table.

column example 3-5

Things to Remember About Column Headers in Excel

  • Always remember to format column headers differently and use Freeze panes to have visibility on the column header at all times. It will help you save time scrolling up and down to understand data.
  • Use the Print Area option and Rows to repeat at every page option while printing. This will make your printing job easy.
  • Selecting the Range and Column header is important while creating a Table in Excel.

Recommended Article

This is a guide to Column Header in Excel. Here we discuss How to use Column Header in Excel, practical examples, and a downloadable Excel template. You can also go through our other suggested articles –

  1. Compare Two Columns in Excel for Matches
  2. Freeze Columns in Excel
  3. COLUMNS Formula in Excel
  4. Excel Header Row
MICROSOFT POWER BI Training
48+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
MS Excel & VBA for Data Science
128+ Hours of HD Videos
24 Courses
10 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
All-in-One Financial Analyst Masters Training Program
1000+ Hours of HD Videos
43 Learning Paths
250+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
All in One Data Science Bundle (360+ Courses, 50+ projects)
1500+ Hour of HD Videos
80 Learning Paths
360+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.7
Primary Sidebar
Popular Course in this category
MS Excel Course
 225+ Hours of HD Videos
36 Courses
13 Mock Tests & Quizzes
  Verifiable Certificate of Completion
  Lifetime Access
4.9
Price

View Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

Download Column Header Excel Template

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Column Header Excel Template

EDUCBA

डाउनलोड Column Header Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more