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
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
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
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.
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
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.
Step 2. Click the "Print Titles" button
This button is in the “Page Setup” section.
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.
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.
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.
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.
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
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.
Step 2. Click the “Insert” tab and select the “Table” button
Confirm that your data selection is correct.
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
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.