How to Repeat Header in Excel Easy & Fast

How to repeat header in excel Automatically easily and quickly? Why do you need to make settings like this in ms excel?
 
When you create a document in Excel in the form of a long table, the printout will also be long and may be more than one page. By default, the table or column titles will only be printed on the first page. Meanwhile, on the next page, only the contents will be printed without the column headings.
 
For the purpose of making it easier to provide information, the column headings in the table should also be printed on the second page and so on. Well, on this occasion, Misnia will share how to repeat headers in Microsoft Excel.
 

How to repeat header in excel Easily

 
In reading a table when there are no column headings that represent the contents of certain data or information, it can be confusing for the reader and difficult to understand.
 
Actually, Microsoft Excel from Microsoft already has a feature to set table titles or column headings to be printed automatically on the second page, next and on each page.
 
The feature is Print Titiles which serves to automatically repeat printing table or column titles or both on each page. Here's how:
  • Turn on your computer and of course run the Ms Excel application.
  • Open your excel document
  • Make sure you are on the Page Layout tab
  • Click the Print Titles Tool
print titles in excel
  • In the Page Setup dialog window, make sure you are on the Sheet tab. Click the Collapse Dialog button to the right of the text box labeled Rows to repeat at top to temporarily hide the Page Setup dialog box and display the Page Setup - Rows to repeat at top dialog box.
How to Repeat Header in Excel
  • Next is to select the row that contains the column headings to be repeated, the trick is to click on the row. To select multiple rows containing column headings to be repeated, click on the first row, press and drag (click and drag) to the next row. The selected line will be surrounded by a dotted line.
repeat header in excel
  • The Page Setup - Rows to repeat at top dialog box automatically contains values ​​depending on the selected row. Click the Collapse Dialog button again to return to the Page Setup dialog box and then click the OK button to end.
 repeat header excel automatically
 
repeat header in ms excel
 
Below is a print preview of the first page where table titles and column headings will be printed on this page.
 
repeat header excel print preview
 
Meanwhile, the following is a print preview of the second page where the column titles that have been previously set using the Print Titles feature will be printed on this page as well as the following pages.
 
repeat header print preview
 
Very easy and fast not a tutorial how to repeat header in excel Automatically with easy and fast. That way you don't have to work hard to make column headings in the table repeatedly on each page. Happy working

Post a Comment for "How to Repeat Header in Excel Easy & Fast"