Put Columns Title For Free

A column title identifies the data in a report. Use the AS phrase to change the default column title for customized data identification or more desirable formatting.

Select a column, and then select Transform > Rename. You can also double-click the column header. Enter the new name.

Select a column, and then select Transform > Rename. You can also double-click the column header. Enter the new name.

Follow these steps to do so: Click the "Insert" tab. Select the "Insert" tab from the top menu. ... Choose "Header & Footer" Select "Header & Footer" from the top menu. ... Select the header and add a title. Click on the newly added header at the top of the sheet.

By default, Excel uses the A1 reference style, which refers to columns as letters (A through IV, for a total of 256 columns), and refers to rows as numbers (1 through 65,536). These letters and numbers are called row and column headings. To refer to a cell, type the column letter followed by the row number.

Select the sheet tab for the sheet for which you want to display multiple header rows or columns. Select the Settings menu. Select the Header Editor icon in the Other Settings section. Select Column Header or Row Header in the Selected Header drop-down box.

To rename the columns, double-click each column header and type the name you want or edit an existing one. To return the transformed data to the Excel worksheet, select Home > Close & Load.

Print row or column titles on every page Click the sheet. On the Page Layout tab, in the Page Setup group, click Page Setup. Under Print Titles, click in Rows to repeat at top or Columns to repeat at left and select the column or row that contains the titles you want to repeat. Click OK. On the File menu, click Print.