How To Set A Title Row In Excel

Download Article

The definitive guide to adding columns headers to your Excel spreadsheet

Download Article

In that location are several means that you can create headers in Excel, and they all serve slightly different purposes. You tin freeze a row so that information technology e'er appears on the screen, even if the reader scrolls downwardly the page. If you want the same header to announced across multiple pages, yous can set specific rows and columns to print on each page. If your data is organized into a table, you can use headers to aid filter the data.

1
Click the View tab. If you want to keep a row of data visible at all times, fifty-fifty when you've scrolled downward the sheet, you tin freeze it.
- You tin set this row to print on all pages as well, which tin be very useful for spreadsheets that span multiple pages. Encounter the next department for details.
ii
Select the frame straight inside the row and column you want to freeze. You lot can fix Excel to freeze rows and columns then that they are ever visible. To practice this, you'll want to select the cell in the corner of the area y'all desire to keep unlocked.
- For example, if you want to keep the top row and the showtime column locked on the screen, highlight cell B2. All columns to the left will be frozen, and all rows above will be frozen.
Advertisement
3

Click the "Freeze Panes" push button and select "Freeze Panes." This will lock the rows above your selected jail cell and the columns to the left of your selected cell. For instance, if you had cell B2 selected, the elevation row and the start cavalcade volition exist locked on the screen.
4

Add emphasis to your header row (optional). Create a visual contrast for this row by centering the text in these cells, applying bold text, calculation a background colour, or drawing a edge under the cells. this tin can help the reader take detect of the header when reading the data on the sheet.

Advert

1

Click the Folio Layout tab. If you accept a large worksheet that spans multiple pages that you need to print, you can set a row or rows to print at the top of every page.
2

Click the "Print Titles" button. You lot'll find this in the Page Setup section.
3

Ready your Print Area to the cells containing the data. Click the push adjacent to the Print Area field then elevate the selection over the data yous want to print. Don't include the column headers or row labels in this option.
4

Click the push button next to "Rows to repeat at top." This will allow you to select the row(s) that yous want to treat as the constant header.
5

Select the row(s) that yous want to turn into a header. The rows that y'all select volition appear at the top of every printed folio. This is great for keeping large spreadsheets readable across multiple pages.
6

Click the push adjacent to "Columns to repeat at left." This volition permit you to select columns that you lot want to keep constant on each page. These columns will human action similar the rows y'all selected in the previous step, and will announced on every printed folio.
vii

Set a header or footer (optional). Click the "Header/Footer" tab and insert a header and/or footer for your print job. You tin can include the company title or document title at the top, and insert page numbers at the bottom. This will assist the reader become the pages organized.
8

Print your sheet . You can transport the spreadsheet to print now, and Excel volition print the information that yous set up with the constant header and columns you chose in the Impress Titles window.

Advertisement

1

Select the data that y'all want to turn into a tabular array. When you convert your data to a table, you can use the table to manipulate the information. One of the features of a table is the ability to set headers for the columns. Note that these are not the same a worksheet column headings or printed headers.
2

Click the Insert tab and click the "Table" button. Ostend that your selection is right.
three
Check the "My tabular array has headers" box and so click "OK." This will create a table from the selected information. The start row of your selection will automatically be converted into column headers.
- If yous don't select "My tabular array has headers," a header row will be created using default names. You tin edit these names by selecting the cell.
4

Enable or disable the header. Click the Design tab and cheque or uncheck the "Header Row" box to toggle the header row on and off. You tin can detect this selection in the Table Manner Options section of the Design tab.^[one]

Ad

Add together New Question

Question

How do I get my headers to change the dates and days automatically?

Use the function @Today. You'll find it near the top under the choice "Functions".

Inquire a Question

200 characters left

Include your e-mail address to become a message when this question is answered.

Submit

The "Freeze Panes" control works equally a toggle. That is, if y'all already have panes frozen, clicking the option again will unfreeze your electric current setup. Clicking it a 2d time volition refreeze the panes in the new position.
Most errors that occur from using the Freeze Panes option are the event of selecting the header row instead of the row just beneath it. If you receive an unintended effect, remove the "Freeze Panes" option, select one row lower and try again.

Thank you for submitting a tip for review!

About This Article

Commodity Summary X

1. Click the View tab.
ii. Select the corner cell under the header row.
3. Click Freeze Panes.
4. Apply formatting to the header row.

Did this summary help you?

Thanks to all authors for creating a folio that has been read ane,009,154 times.

Is this article up to engagement?