Open the Spreadsheet

1. Open the Spreadsheet.
2. Open the spreadsheet where you want to have Excel make the top row a header row.
3. Add a Header Row.
4. Enter the column headings for your data across the top row of the spreadsheet, if necessary.
5. Select the First Data Row.

How do I create a header row in Excel 2007?

To create a custom header or footer in Excel 2007, follow these steps:

1. Click the Page Layout button on the View tab of the Ribbon (or click the Page Layout View button on the Status bar).
2. Position the mouse pointer over the Click to Add Header section at the top or the Click to Add Footer section at the bottom.

How do I name a column in Excel 2007?

Single Sheet

1. Click the letter of the column you want to rename to highlight the entire column.
2. Click the “Name” box, located to the left of the formula bar, and press “Delete” to remove the current name.
3. Enter a new name for the column and press “Enter.”

Where is column headings in Excel?

In Excel and Google Sheets, the column heading or column header is the gray-colored row containing the letters (A, B, C, etc.) used to identify each column in the worksheet. The column header is located above row 1 in the worksheet.

How do I create a heading in Excel cell?

Go to the “Insert” tab on the Excel toolbar, and then click the “Header & Footer” button in the Text group to start the process of adding a header. Excel changes the document view to a Page Layout view. Click on the top of your document where it says “Click to Add Header,” and then type the header for your document.

How do I show column headings in Excel?

Show or hide the Header Row

1. Click anywhere in the table.
2. Go to Table Tools > Design on the Ribbon.
3. In the Table Style Options group, select the Header Row check box to hide or display the table headers.

How do you name a cell in Excel 2007?

Naming cells

1. Select the cell or cell range that you want to name. You also can select noncontiguous cells (press Ctrl as you click each cell).
2. On the Formulas tab, click Define Name in the Defined Names group. The New Name dialog box appears.
3. In the Name text box, type up to a 255-character name for the range.
4. Click OK.

How do I make headings in Excel?

On the Insert tab, in the Text group, click Header & Footer. Excel displays the worksheet in Page Layout view. To add or edit a header or footer, click the left, center, or right header or footer text box at the top or the bottom of the worksheet page (under Header, or above Footer). Type the new header or footer text.

How do you make vertical columns in Excel?

Alternatively, click the gray row number that corresponds to the heading to select all cells in that row. 3. Click the “Home” tab and click the “Orientation” button in the Alignment group. This button is graphically depicted with the angled text “ab.”. 4. Click “Vertical Text” from the Orientation drop-down menu.

How do you select columns in Excel?

Excel keyboard shortcuts select Column:- Select any cell which you want to select Press and hold the CTRL key on your keyboard Press the space key Release the CTRL key and space key and the entire row will be selected If you, want to select more than 1 column, don’t release the shift key, use the arrow key to select more than 1 column

How to add up a column in Excel?

Open your Excel document.

How do you hide extra columns in Excel?

Right-click on the column you want to hide, or select multiple column letters first and then right-click on the selected columns. Select “Hide” from the popup menu. The hidden column letters are skipped in the row number column and a double line displays in place of the hidden rows.