To tell Excel 2007 to repeat one or more rows or columns, first chose the Page Layout tab in the Ruler, then Print Titles (in Excel 2003, choose File | Page Setup, then Sheet).

To tell Excel 2007 to repeat one or more rows or columns, first chose the Page Layout tab in the Ruler, then Print Titles (in Excel 2003, choose File | Page Setup, then Sheet).

To tell Excel 2007 to repeat one or more rows or columns, choose the Page Layout tab in the Ruler, then Print Titles (in Excel 2003, choose File | Page Setup, then Sheet).

To tell Excel 2007 to repeat one or more rows or columns, choose the Page Layout tab in the Ruler, then Print Titles (in Excel 2003, choose File | Page Setup, then Sheet).

You use Microsoft Excel 's built-in function to freeze specific rows and columns (often row or column headers), so when you’re scrolling through, these cells remain stationary on the page.

Microsoft Excel's spreadsheet design allows you to quickly calculate values separated into two columns and replicate this calculation without having to manually recreate the formula for each row.

Using the Text to Columns Tool One way to split data into multiple columns in Microsoft Excel is to use the built-in Text To Columns tool. This method is handy if you prefer to work in a dialog ...