You are viewing the article How to Insert Headline in Excel at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 42,464 times.
There are many ways to create titles in Excel for different purposes. You can freeze a row so that it stays on the screen even if the reader scrolls down. If you want the title to display on more than one page, you can set up rows and columns to print on each page. If the data is sorted into a table, you can use headers to filter the data.
Steps
Freeze rows or columns so they are always visible
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/ea/Add-Header-Row-in-Excel-Step-1-Version-4.jpg/v4-728px-Add- Header-Row-in-Excel-Step-1-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/ea/Add-Header-Row-in- Excel-Step-1-Version-4.jpg/v4-728px-Add-Header-Row-in-Excel-Step-1-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click on the View tab. If you want to set up a row of data to always be visible even when you scroll down, you can choose to freeze that row.
- You can set this row to be printed on all pages. This is very useful when using spreadsheets with multiple pages. Read the next section for more details.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/18/Add-Header-Row-in-Excel-Step-2-Version-4.jpg/v4-728px-Add- Header-Row-in-Excel-Step-2-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/18/Add-Header-Row-in- Excel-Step-2-Version-4.jpg/v4-728px-Add-Header-Row-in-Excel-Step-2-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Directly select the frame inside the row or column you want to freeze. You can set up Excel to freeze certain rows or columns so that they are always visible. First, click a box in the corner of the area you want to unlock.
- For example, if you want to lock the top row and top column on the screen, check cell B2. The entire left column and row above will be frozen.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/69/Add-Header-Row-in-Excel-Step-3-Version-4.jpg/v4-728px-Add- Header-Row-in-Excel-Step-3-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/69/Add-Header-Row-in- Excel-Step-3-Version-4.jpg/v4-728px-Add-Header-Row-in-Excel-Step-3-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the “Freeze Panes” button and select “Freeze Panes.” This is locking the row above the selected cell and the column to the left of the selected cell. For example, if you select cell B2, the first row and first column will be locked on the screen.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f0/Add-Header-Row-in-Excel-Step-4-Version-4.jpg/v4-728px-Add- Header-Row-in-Excel-Step-4-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/f0/Add-Header-Row-in- Excel-Step-4-Version-4.jpg/v4-728px-Add-Header-Row-in-Excel-Step-4-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Add emphasis to the headline (optional). To give this row visual contrast, you can center the text, make it bold, add a background color, or draw a border below the cell. This is a way to help readers pay attention to the headline when reading the data in the table.
Print headlines on multiple worksheets
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/55/Add-Header-Row-in-Excel-Step-5-Version-4.jpg/v4-728px-Add- Header-Row-in-Excel-Step-5-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/55/Add-Header-Row-in- Excel-Step-5-Version-4.jpg/v4-728px-Add-Header-Row-in-Excel-Step-5-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the Page Layout tab. If you need to print a multi-page spreadsheet, you can set up one or more rows to print at the top of each page.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/54/Add-Header-Row-in-Excel-Step-6-Version-4.jpg/v4-728px-Add- Header-Row-in-Excel-Step-6-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/54/Add-Header-Row-in- Excel-Step-6-Version-4.jpg/v4-728px-Add-Header-Row-in-Excel-Step-6-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the “Print Titles” button. You can find this button in the Page Setup section.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/74/Add-Header-Row-in-Excel-Step-7-Version-4.jpg/v4-728px-Add- Header-Row-in-Excel-Step-7-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/74/Add-Header-Row-in- Excel-Step-7-Version-4.jpg/v4-728px-Add-Header-Row-in-Excel-Step-7-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select Print Area as the cell that contains the data. Click the button next to the Print Area field and drag the mouse to select the entire data area you want to print. Do not select columns or header rows.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/47/Add-Header-Row-in-Excel-Step-8-Version-2.jpg/v4-728px-Add- Header-Row-in-Excel-Step-8-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/47/Add-Header-Row-in- Excel-Step-8-Version-2.jpg/v4-728px-Add-Header-Row-in-Excel-Step-8-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the button next to “Rows to repeat at top” . This button allows you to select one or more lines as headings.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/3e/Add-Header-Row-in-Excel-Step-9-Version-2.jpg/v4-728px-Add- Header-Row-in-Excel-Step-9-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/3e/Add-Header-Row-in- Excel-Step-9-Version-2.jpg/v4-728px-Add-Header-Row-in-Excel-Step-9-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select the line you want as the title. The selected line will appear at the top of each printed page. This is quite effective when reading spreadsheets with many pages.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2a/Add-Header-Row-in-Excel-Step-10-Version-2.jpg/v4-728px-Add- Header-Row-in-Excel-Step-10-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/2a/Add-Header-Row-in- Excel-Step-10-Version-2.jpg/v4-728px-Add-Header-Row-in-Excel-Step-10-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the button next to “Cpumns to repeat at left” . This button allows you to select one or more columns to appear consecutively on each page. These columns serve the same role as the rows you selected in the previous step, they will appear on each printed page.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6a/Add-Header-Row-in-Excel-Step-11-Version-2.jpg/v4-728px-Add- Header-Row-in-Excel-Step-11-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/6a/Add-Header-Row-in- Excel-Step-11-Version-2.jpg/v4-728px-Add-Header-Row-in-Excel-Step-11-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Set header or footer (optional). Click on “Header/Footer” and insert a header and/or footer into the document you want to print. You can put your company or document name at the top of the page and insert the page number below. This is also how the page is arranged for the reader.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/90/Add-Header-Row-in-Excel-Step-12-Version-2.jpg/v4-728px-Add- Header-Row-in-Excel-Step-12-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/90/Add-Header-Row-in- Excel-Step-12-Version-2.jpg/v4-728px-Add-Header-Row-in-Excel-Step-12-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Print table. Now that you can send the spreadsheet to the printer, Excel will print the data set with the headers and columns repeated in the Print Titles window. [1] X Research Source
Create headers in tables
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c6/Add-Header-Row-in-Excel-Step-13-Version-2.jpg/v4-728px-Add- Header-Row-in-Excel-Step-13-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c6/Add-Header-Row-in- Excel-Step-13-Version-2.jpg/v4-728px-Add-Header-Row-in-Excel-Step-13-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select the data you want to create the table. When you convert data to a table, you can use the table to manipulate the data. One of the functions of a table is to set a column header. Note, this header is not the same as the column header of the spreadsheet or the printed title.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/68/Add-Header-Row-in-Excel-Step-14-Version-2.jpg/v4-728px-Add- Header-Row-in-Excel-Step-14-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/68/Add-Header-Row-in- Excel-Step-14-Version-2.jpg/v4-728px-Add-Header-Row-in-Excel-Step-14-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the Insert tab and then click the “Table” button. Confirm your selection is correct.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/ce/Add-Header-Row-in-Excel-Step-15-Version-2.jpg/v4-728px-Add- Header-Row-in-Excel-Step-15-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/ce/Add-Header-Row-in- Excel-Step-15-Version-2.jpg/v4-728px-Add-Header-Row-in-Excel-Step-15-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Check the “My table has headers” dialog box and click “OK”. The program will create a table from the selected data. The first line selected is automatically moved to the header column.
- If you do not select “My table has headers”, the header line will use the default name. You can edit the name by clicking the box.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2c/Add-Header-Row-in-Excel-Step-16-Version-2.jpg/v4-728px-Add- Header-Row-in-Excel-Step-16-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/2c/Add-Header-Row-in- Excel-Step-16-Version-2.jpg/v4-728px-Add-Header-Row-in-Excel-Step-16-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Enable or disable headers. Click on the Design tab and select or deselect the “Header Row” dialog box to enable or disable headers. You can find this option in the Table Style Options section of the Design tab. [2] X Research Source
Advice
- The “Freeze Panes” command acts as a switch. If you have frozen the selected area, clicking this button will unfreeze the current settings. Clicking again will freeze a new location.
- Most common mistakes when using Freeze Panes are because you choose the headline instead of the line below. If the results are not satisfactory, remove the “Freeze Panes” option, select 1 line lower and try again.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 42,464 times.
There are many ways to create titles in Excel for different purposes. You can freeze a row so that it stays on the screen even if the reader scrolls down. If you want the title to display on more than one page, you can set up rows and columns to print on each page. If the data is sorted into a table, you can use headers to filter the data.
Thank you for reading this post How to Insert Headline in Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: