When you’re ready to put that Excel table to work, you have options to sort, filter, and search your table data. On the right side of the ribbon, use the arrows to view and then select a color scheme.
Whether you started your table with a particular style or just used the default, you can change it here. Check the boxes for the items that you want to display. In the center of the ribbon are checkboxes to show things like a total row, the first and last columns, and the filter button. Enter the name you want to use in the “Table Name” field. You can give your table a more meaningful name, which is helpful if you plan to reference it in your workbook. Table nameĮach table you create is given a default name of Table 1, Table 2, and so on. Open that tab and check out the following options. Select any cell in the table and you’ll see the “Table Design” tab appear above the ribbon. Now that you have your table, you can customize it. Just note that if you do have a header row but choose not to use the feature, that row will then be treated as data, which affects your table filtering. If you do not check the box to use table headers, Microsoft Excel will assign them by default as Column 1, Column 2, and so on, which you can edit if you wish. If you want to use your own header row for the table, check the box for “My Table Has Headers” and click “OK” when you finish. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.You can either manually edit the cell range in the box or drag your cursor through the area on your sheet while the window remains on the screen. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. Preview of page 2 with header row Instant Connection to an Excel Expert Preview of page 1 with header rowįigure 11. This method ensures that the selected header row (row 2) is repeatedly displayed on every page as we print or preview the worksheet.įigure 10.
Output: Freeze header row Add print titleįor long lists or large data sets that are more than one page, it is very helpful to have a header row so that our data is properly labelled in every page that we print or preview. 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 TABLE WITH HEADERS IN EXCEL 2016 HOW TO
Final result: How to make a header rowįigure 2. 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.
0 kommentar(er)
