Posted 20 January 2011 - 02:05 PM
Excel 2003 provides an option in page setup to repeat certain rows at the top of your screen as you scroll downward. This is really helpful for column headings.
I have selected row 1 to repeat at the top of the screen; however, rows 1 and 2 are repeating. The formula in the page setup for rows to repeat is "$1:$1". Isn't that correct? If so, why are rows 1 and 2 repeating?