Skip to content
LogoTechnipages
LogoTechnipages
  • Topics
        • Android
        • Browsers
        • Gaming
        • Hardware
        • Internet
        • iPhone
        • Linux
        • macOS
        • Office
        • Reviews
        • Software
        • Windows
        • Definitions
        • All Recent Posts
  • Product Reviews
  • About

Excel: Make Header Row

Mel HawthorneFebruary 25, 2020 Comments (0)
Excel Header

Creating a sticky header row is a great tool for making it easier to keep track of data in spreadsheets. It’s easy too – look below for instructions on how to set the top row of your spreadsheet to remain stuck even as you scroll down.

First, open your spreadsheet and make sure all the data you want is in the table. If not, at least make sure that all the columns are set up correctly and labelled. The top row will be the header bar – that means that that’s where you need to place your titles. For example, ‘Item Number’ or ‘Last Name’. Set at least one row of info if your table is otherwise empty, and mark all the columns that will contain info.

When that’s done, click on the Home button on the ribbon menu and select the option Format as Table. Pick one of the design pre-sets that features a prominent header row, and click on it. A new window will open where you can adjust the range of data if necessary, but more importantly, one where you can tick the box ‘My table has headers’.

Select ‘My table has headers’.

Make sure it is ticked and click confirm. The styling you chose will now show on your spreadsheet – and the top row featuring your titles will remain sticky if you scroll down the table.

An example of a sticky header row.

Tip:

If it seems like the header row isn’t sticking, make sure the field you have selected by clicking on it is part of the table. Clicking outside of it temporarily hides the sticky header, as it is possible to have more than one per spreadsheet – to set up multiple tables in one spreadsheet, repeat the above steps for each one.

Categories: Office

Author Mel Hawthorne

You Might Also Like

  • fix Office 365 Unable to Access Shared Mailbox

    Office 365: Unable to Access Shared Mailbox

    Madalina DinitaOffice
  • automatically-adjust-column-width-excel

    Excel: How to Tilt Text in Cells

    Judy SanhzOffice
  • Outlook Get Add-ins Button Is Grayed Out Top 5 Solutions in 2023

    Outlook Get Add-ins Button Is Grayed Out: Top 5 Solutions in 2023

    Tamal DasOffice
  • Outlook Email View Changed The 5 Best Ways to Fix It

    Outlook Email View Changed: The 5 Best Ways to Fix It

    Susan SheffieldOffice

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Google Docs Header

How to Add a Text Watermark in Google Docs

How to Enable Dark Mode on WhatsApp Updated Methods for 2023

How to Send HD Pictures and Videos on WhatsApp

How to Share Files Using Google Nearby Share

How to Share Files Using Google Nearby Share

Android Battery Will Not Charge Fix

Android Battery Will Not Charge Fix

Turning on Triple Touch Zoom on Android

Turning on Triple Touch Zoom on Android

profile pic

The Experts Behind Technipages

My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

Learn More

technipages logo white
linkedin icon

Technipages is part of Guiding Tech Media, a leading digital media publisher focused on helping people figure out technology. Learn more about our mission and team here.

© 2023 Guiding Tech Media All Rights Reserved

  • About Us
  • Contact
  • Legal & Privacy

© 2023 Guiding Tech Media All Rights Reserved

Information from your device can be used to personalize your ad experience.
Do not sell my personal information.