How to Add a Title Row in Excel (with Pictures)

Table of contents:

How to Add a Title Row in Excel (with Pictures)
How to Add a Title Row in Excel (with Pictures)

Video: How to Add a Title Row in Excel (with Pictures)

Video: How to Add a Title Row in Excel (with Pictures)
Video: 3 MOST FAMOUS Celebrities in my Contact List are... #shorts 2024, November
Anonim

There are several ways you can follow to create headings in Excel, and each step serves a different purpose. You can “freeze” the row so that it always appears on the screen, even if the reader or user scrolls the page. If you want the same title to appear on multiple pages, you can select specific rows and columns to print on each page. You can also use headings to filter data if your data is managed in tabular form,.

Step

Part 1 of 3: Freezing Rows or Columns to Keep Showing on Screen

Add Header Row in Excel Step 1
Add Header Row in Excel Step 1

Step 1. Click the “View” tab

If you want rows of data to always be displayed, even when the worksheet is shifted, you can freeze those rows.

You can set this line to print on all pages. This step is especially useful for spreadsheets that have multiple pages. See the next method for further steps

Add Header Row in Excel Step 2
Add Header Row in Excel Step 2

Step 2. Select the boxes directly within the rows and columns that you want to freeze

You can instruct Excel to freeze rows and columns so that they are always displayed on the screen. Select the box in the corner of the area you don't want to lock.

For example, if you want to lock the top row and first column so that they are always displayed on the screen, check the box “B2”. All the columns that are on the left side of the box and the rows above it will be frozen

Add Header Row in Excel Step 3
Add Header Row in Excel Step 3

Step 3. Click the " Freeze Panes " button and select " Freeze Panes"

The rows above the selected box and the columns to its left will be locked. For example, if you select the “B2” box, the top row and first column on the spreadsheet will be locked on the screen.

Add Header Row in Excel Step 4
Add Header Row in Excel Step 4

Step 4. Highlight the title bar (optional)

Create a visual contrast to this line by centering the text on the box, bolding it, adding a background color, or creating a frame below the box. By giving emphasis, the reader or user can know the title when reading the data on the spreadsheet.

Part 2 of 3: Printing Headlines on Multiple Pages

Add Header Row in Excel Step 5
Add Header Row in Excel Step 5

Step 1. Click the “Page Layout” tab

If you have a worksheet with multiple pages that need to be printed, you can set one or more lines to print or add at the top of each page.

Add Header Row in Excel Step 6
Add Header Row in Excel Step 6

Step 2. Click the "Print Titles" button

This button is in the “Page Setup” section.

Add Header Row in Excel Step 7
Add Header Row in Excel Step 7

Step 3. Set the print area on the boxes containing the data

Step 4. Click the button next to " Rows to repeat at top"

With this option, you can select the rows you want to set as fixed headings.

Add Header Row in Excel Step 9
Add Header Row in Excel Step 9

Step 5. Select the row you want to change as the title row

The selected line will be displayed at the top of each printed page. With this feature, large spreadsheets can be easily read because the title is still displayed on each page.

Add Header Row in Excel Step 10
Add Header Row in Excel Step 10

Step 6. Click the button next to the “Columns to repeat at left” option

With this button, you can set a specific column as a constant column on each page. These columns will act like the rows previously selected in the previous step, and will appear on each page that will be printed.

Add Header Row in Excel Step 11
Add Header Row in Excel Step 11

Step 7. Set the page header or footer (optional)

Click the " Header/Footer " tab and enter a title and/or “foot” text for the document. You can add a company name or document title at the top of the page, and insert page numbers at the bottom. These two elements help readers or users to manage pages neatly.

Add Header Row in Excel Step 12
Add Header Row in Excel Step 12

Step 8. Print the spreadsheet

You can print the spreadsheet at this point. Excel will print the predefined data with the row and column headings previously selected in the “Print Titles” window.

Part 3 of 3: Creating a Title on the Table

Add Header Row in Excel Step 13
Add Header Row in Excel Step 13

Step 1. Select the data you want to convert into a table

When you turn data into a table, you can use it to manipulate the data. One of the features that tables have is the ability to set column headings. Keep in mind that the column headings in the table are not the same as the worksheet column headings or document titles.

Add Header Row in Excel Step 14
Add Header Row in Excel Step 14

Step 2. Click the “Insert” tab and select the “Table” button

Confirm that your data selection is correct.

Add Header Row in Excel Step 15
Add Header Row in Excel Step 15

Step 3. Check the box " My table has headers " and click " OK"

The table will be created from the selected data. The first row in the selection will automatically be changed to column headings.

If you do not select " My table has headers ", a title line will be created using the program's default name. You can edit this name by selecting the box

Add Header Row in Excel Step 16
Add Header Row in Excel Step 16

Step 4. Show or hide the title

Click the “Design” tab and check or uncheck the “Header Row “box to show and hide titles. You can see these options in the “Table Style Options” section of the “Design” tab.

Tips

  • The “Freeze Panes” command functions as a button or “switch”. This means that if you've already frozen a box or pane, you can re-click the option to unfreeze the currently enabled one. Click the option a second time to refreeze the box or pane to a new position.
  • Most of the errors that occur when using the “Freeze Panes” option occur due to the selection of the title row, and not the row below it. If you see unwanted results, remove the " Freeze Panes " option, select one line below the title bar, and try again.

Recommended: