MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I want text to appear automatically at the top of every page

Posted by Jennifer on December 22, 2000 12:36 PM

I have two rows of text that I've typed to appear at the top of every page, automatically.

I want the first row (a big, merged cell, which I made my workbook title), as well as the next row of cells (column titles) to appear autmatically at the top of every page--any hints on how to do that?

I tried the Header option, but it won't let me a) do colors nor b)type in those titles for every column

Thanks! Jennifer

Posted by Bruce on December 22, 2000 12:49 PM

Go to File, Page Setup,slect the sheet tab, and then select Rows to repeat at Top.

This will make these rows appear on every printed page.