B BH Nov 14, 2003 #1 I am wanting to have a row of Header Columns that comes up on every page- How do you do that?
J JMay Nov 14, 2003 #2 File, PageSetUp... Sheet Tab, Rows to Repeat at Top, Click inside and enter something like $1:$3 (for Rows 1, 2 & 3- which could be your column headers)... HTH
File, PageSetUp... Sheet Tab, Rows to Repeat at Top, Click inside and enter something like $1:$3 (for Rows 1, 2 & 3- which could be your column headers)... HTH
B BH Nov 14, 2003 #4 Excelent answer! Now I need the headers to show up on the normal screen (I am using it for a template). Do I need to set something in my prefs?
Excelent answer! Now I need the headers to show up on the normal screen (I am using it for a template). Do I need to set something in my prefs?
J JMay Nov 14, 2003 #5 Don previously answered on how to duplicate header "in the screen" by Grouping across several sheets... and entering data just once..
Don previously answered on how to duplicate header "in the screen" by Grouping across several sheets... and entering data just once..