EXCEL ZE TOP ROW AND FIRST COLUMN HOW TO

To add headers or footers to your printed worksheet, see Headers and footers in worksheets. To print specific data at the top or side of each printed page-such as the names of the months that appear across the first row of a worksheet-see Repeat row or columns on every printed page. You can also set your data up as an Excel table, which can automatically set the first row as a header row. For more information, see Fill data automatically in worksheet cells.

You can use the fill feature in Excel to quickly generate labels, such as a series of months. For example, you might label monthly sales numbers by entering the month names in cell A1 through L1. If your goal is to label columns or rows in your worksheet, just click a cell, type the text that you want to use, and then press TAB to move to the next cell. You can't customize the numbers and letters in row and column headings. If you're using Excel 2007, click the Microsoft Office Button and then click Excel Options > Formulas. To switch back to A1 reference style, go to File > Options > Formulas, and then, under Working with formulas, uncheck the R1C1 reference style check box. If you see numbers instead of letters in the column headings, your workbook is using the alternative R1C1 reference style. To preview the worksheet before printing, press CTRL+F2.īy default, Excel uses the A1 reference style, which refers to columns as letters and rows as numbers. To print the worksheet, press CTRL+P to open the Print dialog box, and then click OK. To demonstrate this, we are going to freeze four rows and two columns in the sheet. But it is more practical to freeze some rows and columns in our everyday Excel usage.

EXCEL ZE TOP ROW AND FIRST COLUMN HOW TO

In the previous section, we discussed how to freeze either rows or columns. Note: You can also click the small expansion icon, and then under Print, select the Row and column headings check box. Freeze Selected Columns and Rows at the Same Time.

Excel ze top row and first column