Excel Tips No 15 : Print A Big Data With The Same Column Title

This free microsoft excel tips no 15 is telling How to Print A Big Data With The Same Column Title. For Example is the data below. The Data contain thousand number of transaction (no 1000, 1001, ...), but we want the title of column (ie 3rd rows) will be printed on the first row for every page you print. He is the setting


1. Click Page Set up
2. Click "sheet" tab
3. Fill field "Rows to repeat at top (ie : Third Row, that contain column title) You can do it by click the red arrow and click Third Row or fill the constant number $3:$3.
4. Click OK
5. Now, every time you print this worksheet, the third row will be printed first time before another data.


May it can be useful for you.