If you rename the header rows and then turn off the header row, the original values you input will be retained if you turn the header row back on. In the Table Style Options group, select the Header Row check box to hide or display the table headers. Go to Table Tools > Design on the Ribbon. All other worksheet references (such as A1 or RC style references) to the table header are adjusted when the table header is turned off and may cause formulas to return unexpected results. References in tables to a hidden table header return zero (0) values, but they remain unchanged and return the table header values when the table header is displayed again. Instead, a default table header is added that you can change when you display table headers.Īlthough it is possible to refer to table headers that are turned off in formulas, you cannot refer to them by selecting them. Then double-click any one of the column partition lines.
Note: In case you still have the Page Setup window opened on the Sheet tab, just check the Row and column headings box in the Print section. Go to the Sheet Options group on the PAGE LAYOUT tab. This only works when table headers are displayed. Click where the row and column headers meet, this will select the entire sheet, like so: alt text. Open the worksheet that you want to print with the row and column headings.
#How to show header in excel 2013 series#
When you add a new column when table headers are not displayed, the name of the new table header cannot be determined by a series fill that is based on the value of the table header that is directly adjacent to the left of the new column. When you turn the header row off, AutoFilter is turned off and any applied filters are removed from the table. For more information, see Print rows with column headers on top of every page. The table header row should not be confused with worksheet column headings or the headers for printed pages. If you have a different version your view might be slightly different, but unless otherwise noted, the functionality is the same.
#How to show header in excel 2013 how to#
The screen shots in this article were taken in Excel 2016. How to display or hide Row & Column Headers in Excel Display or hide Row & Column headings in active worksheet One click to hide or show the Ribbon Bar/.
0 kommentar(er)
