how to keep headers in excel 2016 when scrolling

#HOW TO KEEP HEADERS IN EXCEL 2016 WHEN SCROLLING HOW TO#

Select the first row which should be your header row.When the 'Format As Table' dialog comes up, select the 'My table has headers' checkbox and click the OK button.With a cell in your table selected, click on the 'Format as Table' option in the HOME menu.Make the first row the header row that you wish to see in the columns by giving it short meaningful names.Using Microsoft Excel 2013 or later (haven't tried earlier versions), create a table in Excel.

However, if you format the entire table as a Table, then Excel has a useful trick to enable such a feature. To fix this, just change the background color of the cells in the header row to something other than “No Color.” Select the top row of the table, press F4 to show the Properties window, click the dropdown of the BackgroundColor property, and chose a color, such as White or any other color (if you choose a dark color for the background, it may be difficult to read the column headers, and you may have to change the Color property, which controls the foreground color, to something light).Excel does not give an easy way of changing your column headings to something other than the built-in A, B, C or 1, 2, 3 (R1C1) format. Notice that the column header stays put, but because its background is transparent by default, things look messy. After you set the FixedData property to True, preview your report and try scrolling. You will have to find where that static item ended up, undo the property changes on it, and reset those properties on the new first static item.)Īlas, we are not quite out of the woods, yet. If you change the table in a way that changes what the first row was when you set these properties, what used to be the first static item will no longer be the first one. (A note of caution: Keep in mind that this approach works as long as these properties are always set on the first static item. To prevent scrolling, set FixedData to True. You’ll need to set two properties to make the column headers repeat on every page: KeepWithGroup must be set to After and RepeatOnNewPage must be set to True. Select the first Static item and press F4 to display its properties in the Properties window. The good news is that you don’t need to understand it in order to use it for what we’re doing as long as you keep in mind that you always work with the first static item in the list. Do this by selecting Advanced Mode from the dropdown off to the right side of the groups panel.ĭon’t be alarmed by what you see next! This is a notoriously confusing layout that many people struggle to understand. Start by putting the group panel at the bottom of the report design screen into advanced mode. With both of these properties set to False, we’re ready to configure the tablix to repeat and freeze the column headers. When working with tables, you want to make sure these properties are both set to False.

FixedColumnHeaders will prevent column headers in a matrix from scrolling off the top of the page and RepeatColumnHeaders will make sure that column headers in a matrix appear at the top of every page in the tablix. There are two properties you’re looking for. Then, in the dropdown at the top of the Properties window, select the tablix in your report for which you want to control column headers. Press F4 to display the Properties Window. For the approach I’ll be showing you here to work properly, those properties have to be set to False. I’ll show you a way to accomplish these things using an approach that does work however, be warned: the way to do this is clunky, counter-intuitive, and requires maintenance if you make certain changes to your tables.įirst, let me show you the properties that don’t work in a table. While tablixes have properties for these things, they only work in matrix tablixes but not in tables.

#HOW TO KEEP HEADERS IN EXCEL 2016 WHEN SCROLLING HOW TO#

In this article I’ll show you how to configure a table tablix to both repeat column headers at the top of every page and freeze them while scrolling.

How to keep headers in excel 2016 when scrolling