Click View tab > Freeze Panes > Freeze PanesĪfter freezing, the header row will always be present on-screen even when we scroll down to the last row in the worksheet.įigure 8.Click the second row of data, or the row just below our header row.In order to freeze the first row so that it is always visible on screen, we follow these steps: When navigating through a list or data that consists of many rows, it is wise to freeze the first row of data such that we can always see the labels even when we have scrolled so far down the worksheet. Output: Format as table Freeze header row We have successfully formatted our data as a table with a header row, and Excel automatically adds filter arrows that can be used to sort or filter the values per column.įigure 6. Verify the range B2:F7 for our data set and ensure that the checkbox is ticked for My table has headers. The Format As Table dialog box will appear. Click Home tab > Format as Table > Table Style Light 9.In order to format our data as a table, we follow these steps: Now we can easily identify the first row as the header row. Fill the cell with color: Blue, Accent 5, Lighter 60%.We can make the first row as header by changing the format of the first row of data in order to make its appearance distinct from the other cells.
#How to insert a header in excel mac 2016 how to#
Final result: How to make a header rowįigure 2.
![how to insert a header in excel mac 2016 how to insert a header in excel mac 2016](https://www.lifewire.com/thmb/KFjV9HtKx4scb4msxd7yUnStQOw=/1920x896/filters:no_upscale():max_bytes(150000):strip_icc()/InsertTextHF-5c7c410f46e0fb0001a983d5.jpg)
Fortunately, Excel offers several ways to make a header row that will help us become more efficient and effective in presenting and handling data on a spreadsheet.įigure 1. How to make an Excel header row – ExcelchatĪ table without a header row can cause confusion and reduce efficiency in tracking and managing data because we always have to wonder what each of the values are referring to.