If I have a series of row labels along the left edge of a long horizontal table of data, how can I make those labels show up on each left edge of the table data for each page when printing. I don't want to have to manually insert these cells/row labels. I just want the labels to show up kind of like headers or footers do, but as labels to the data.
does this make any sense?
Last edited by Darkmatter; 05-01-2009 at 11:56 AM.
In Excel 2007 click on "Print Titles" button on the right side of the "Page Setup" section in the "Page Layout" Ribbon. Under the Sheet Tab Used the selection Button to Highlight the Rows and Columns you want to repeat. Columns being your Row Titles and Row being your Column Titles.
Thanks, worked great!
No problem. Don't forget to Edit Post and marked as solved :-D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks