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 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.
