Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Excel: Repeating Rows at the top of the screen


  • Please log in to reply
2 replies to this topic

#1 Hal06

Hal06

  • Members
  • 927 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:New York, New York, USA
  • Local time:01:32 PM

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?

Thank you.

BC AdBot (Login to Remove)

 


#2 Eyesee

Eyesee

    Bleepin Teck Shop


  • BC Advisor
  • 3,545 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:In the middle of Kansas
  • Local time:01:32 PM

Posted 20 January 2011 - 06:11 PM

I dont do it in page setup unless you are talking about printing column headings on a report.
Thats different.

Click on where you want the slit to occur in the worksheet then click the window menu & split.
In the beginning there was the command line.

#3 Hal06

Hal06
  • Topic Starter

  • Members
  • 927 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:New York, New York, USA
  • Local time:01:32 PM

Posted 21 January 2011 - 03:39 PM

Thanks!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users