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
- 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.
- 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.
- 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.
Below is a print preview of the first page where table titles and column headings will be printed on this page.
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.
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"