• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Gaming
    • Hardware
    • Internet
    • iOS
    • MacOS
    • Office
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About Technipages
Excel: Make Header Row

Excel: Make Header Row

By Mel Hawthorne Leave a Comment

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.

You Might Also Like

  • Excel: Add Header and Footer
    Excel: Add Header and Footer
  • How to Add a PDF to Excel
    How to Add a PDF to Excel
  • Excel: Shade Every Other Row
    Excel: Shade Every Other Row
  • Excel: Add Watermark
    Excel: Add Watermark
  • Fix Excel Freezing or Slow
    Fix Excel Freezing or Slow
  • Excel Calculations Are Wrong
    Excel Calculations Are Wrong
  • How to Convert Excel Spreadsheet to PDF
    How to Convert Excel Spreadsheet to PDF
  • How to Spell Check in Excel
    How to Spell Check in Excel
  • How to Merge Sheets in Excel
    How to Merge Sheets in Excel

Filed Under: Office Tagged With: Excel 2019

Reader Interactions

Did this help? Let us know!

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.

Primary Sidebar

Recent Posts

  • How to Enable Dark Mode in Firefox
  • Windows 11: How to Add Clocks with Different Time Zones
  • Google Assistant: How to Never Miss a Birthday
  • Windows 11: How to Disable Notifications and Ads
  • How to Use Oculus Quest 2 Air Link
  • How to Create an Avatar in the Oculus Quest 2
  • 5 Free and Fun Math Apps for Kids
  • Windows 11: How to Discover What Graphics Card You’re Using

Who’s Behind Technipages?

Baby and Daddy 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.

© Copyright 2022 Technipages · All Rights Reserved · Privacy