How to make Excel Header float or sticky (Free Template)

When dealing with a large Excel spreadsheet, it can be tedious to scroll up and down to check the header. Luckily, we can make the Excel header float or sticky for efficiency. When you make the Excel header float, you can check the headings no matter how further down you are in your Excel File. Additionally, a sticky header can be useful when printing Excel

In this article, I will guide you on how to make the Excel Header float Sticky.

How to make Excel Header float in one Spreadsheet

Step 1: Navigate to the Spreadsheet where you wish to make the header float.

Step 2: Select the row number of your header to highlight the whole row

Step 3: Click View, then freeze panes down and select freeze panes. If your header is the first row of the document, select freeze top row. Otherwise, if it is in another position, you need to select the freeze panes options

How to float Excel Header

How to make the Excel Header float using the Table method

One of the easiest ways to make the Excel header float or sticky as you scroll by converting the whole data into a table. Excel automatically freezers the header row in tables sticky to float as you scroll. Follow these simple steps

Step 1: Highlight the whole range containing data in your Spreadsheet. You can highlight all the data in your Spreadsheet by using the shortcut ctrl+A

Step 2: Use the shortcut ctrl+T to convert the data into a table

Step 3: A pop-up menu will appear, prompting you to set the range and accept if your table contains a header. Tick this option and click okay.

Step 4: As you scroll down, you will notice that the header row has become sticky and floats down.

How to make Excel Header float in all spreadsheets in Excel

If you are working with a workbook containing many spreadsheets, you need a more efficient way to float all the headers. Doing it manually can take a lot of hours. Follow these steps to make the excel header sticky in all spreadsheets.

Step 1: First download and install the Extend office software known as Kutools by visiting this website

Step 2: A new tab on your Excel workbook labeled as Kutools Plus will be added. Click on this tab

Step 3: Under the kutools plus tab, navigate to worksheets and click on it to launch more options

Step 4: Now select freeze panes multiple worksheets.

How to make first Excel Column float or sticky in Excel

In Excel, you can add data in approximately 16,384 columns. Reading data in all these columns can be hard, especially without the guide from the first column. By default, the column that is numbered floats to the end. However, this might not be enough, as you may include other important data in the first column to guide the rest of the data. For this reason, you need to make the first column sticky. Follow these simple steps:

Step 1: Select or highlight the first column by selecting the column number

Step 2: Click on View, then the freeze panes dropdown

Step 3: Under the freeze panes section, select freeze the first column

Scrolling to the right side, you will notice that the first column has become sticky or floats. Additionally, you will realize a slightly different border separating the first column from the second.

Shortcut to float Excel Header

Are you looking for the fastest way to float the header in Excel? Excel shortcuts make it easier for users to perform quick actions using shortcuts.

The shortcut to float the header in Excel is alt+W+F+R

The shortcut to float the first column is: alt+W+F+C

Shortcut to float the first few rows: Alt+W+F+f

Steps to float Excel header using a shortcut

Select the first cell of the Spreadsheet you wish to freeze

Then press the shortcut on your keyboard, alt+W+F+R. Start by pressing alt+w simultaneously then, followed by the rest of the keys

A unique number represents every item on the menu/toolbar. Visit this page to learn more about Excel

Download the practice template

Using VBA

VBA code allows users to make short applications that perform some actions. In this section, I will show you how to float the first row using VBA code.

Step 1: Click on the developer tab

Step 2: Click on Visual basics

Step 3: Click on insert, then the module

Step 4: Copy and paste the following VBA code on the window that appears

Sub FreezeTopRow()
    ActiveWindow.SplitRow = 1
    ActiveWindow.FreezePanes = True
End Sub

Step 5: Go back to the Spreadsheet and click on the developer tab, then Macros

Step 6: Click run on the freeze top row macro

Similar Read: How to Freeze Excel Top Row and First Column

Final Thoughts

There are many ways to do this. You can make the top row float or sticky as you scroll down the Spreadsheet. For example, using a shortcut, VBA, or the access menu. Making the top row sticky is useful when printing long pages and dealing with spreadsheets with a lot of data.

Leave a Reply

Discover more from Excel Wizard

Subscribe now to keep reading and get access to the full archive.

Continue reading