Go Back  DVD Talk Forum > General Discussions > Tech Talk
Reload this Page >

Yet another Excel Question - Header Row?

Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

Yet another Excel Question - Header Row?

Old 09-10-04, 02:51 AM
  #1  
DVD Talk Hall of Fame
Thread Starter
 
Blake's Avatar
 
Join Date: Feb 1999
Location: Orange
Posts: 7,737
Likes: 0
Received 0 Likes on 0 Posts
Yet another Excel Question - Header Row?

Basically, I need a certain row to print at the top of each new page. I don't really want to have to insert a row at the top of each page and then have to copy and paste the row into the inserted row, though I will if I have to. I just figured, there's got to be a way to have a sort of "header" row that prints atop all other rows when printing.

I already set up a header in the "Header & Footer" and didn't see any way to specifcy, say, ROW A as a header row to print atop each page.

Is this possible or am I just going to have to copy & paste a lot?
Old 09-10-04, 02:53 AM
  #2  
DVD Talk Hall of Fame
Thread Starter
 
Blake's Avatar
 
Join Date: Feb 1999
Location: Orange
Posts: 7,737
Likes: 0
Received 0 Likes on 0 Posts
Well...guess I should have tried google first...

http://office.microsoft.com/en-us/as...346461033.aspx

ETA: Just tested it here...hope it works at work.

In case you don't want to go to the site:

Repeat row and column headings on printed pages

1. Click Page Setup on the File menu.
2. Click the Sheet tab, and then do one or both of the following:
* To repeat row labels on every page, click Rows to repeat at top, and then enter the rows that contain the column labels.
* To repeat column labels on every page, click Columns to repeat at left, and then enter the columns that contain the row labels.

Last edited by Blake; 09-10-04 at 02:55 AM.

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information -

Copyright 2021 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.