How do you put a heading in three columns properly in Excel

Default Excel Column Headings

Open the Spreadsheet

Open the Excel spreadsheet where you want to define your column headings.

Use the Page Layout Tab

CLICK the "Page Layout" tab at the top of the ribbon, then find the Sheet Options area of the ribbon, which includes two small checkboxes under the Headings category.

Check to Show Headings

Add or remove a check mark next to "View" to reveal or hide, respectively, the Excel headings on the spreadsheet. The headings for the columns and ROWS are linked, so you can only either see them both, or hide them both. The column headings will be letters and the row headings will be numbers.

Choose Whether to Print Headings

Place a check mark in the box next to "Print" to have Excel include the column and row headings on anything that you print out. These headings will appear on every page that you print, not just the first.

Customized Column Headings in Excel

Open the Spreadsheet

Open the spreadsheet where you want to have Excel MAKE the top row a header row.

Add a Header Row

Enter the column headings for your data across the top row of the spreadsheet, if necessary. If your data is already present in the top row, right-click on the number "1" on the top of the left side of the spreadsheet and choose "Insert" from the pop-up menu to create a new top row, then enter your headings by typing in the appropriate cell.

Select the First Data Row

Click on the number "2" on the left side of the spreadsheet to select the second row, which is the now the first row under the headings and the first containing actual data.

FREEZE the Headers in Place

Click the "View" tab in the ribbon menu, and then click the "Freeze Panes" button in the Window area of the ribbon. Your column headers now stay visible as you scroll down the spreadsheet, letting you see which column is which as you edit the document.

Configuring Printing Options

Click the "Page Layout" tab if you want your headers to print on every page of the spreadsheet. Click the arrow next to "Sheet Options" in the ribbon to open a small window. Check the box next to "Rows to REPEAT at top," which shrinks the window and takes you back to the spreadsheet. Click the number one on the left side of the spreadsheet, and then click the small box again to return the window to its normal size. Click "OK" to save your changes.