 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / August 2007Excel sheet: scroll down, but leave first lines visible
Hi all Have to solve a problem fast: Excel sheet has in the first 4 lines text that i want to have visible at all times ( fix on top ) even when i scroll down on the sheet...... How can i do it. Thanks for your help either here in the NG or to: wette-2(at)ballonfahrer(dot)ch Hans Select the Row under the last one that you want to remain visible and the select Window > Freeze Panes If you want the first 4 line to also print on every page then select File > Page Setup > Sheet > Rows to Repeat at top enter 1:4  SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > Hi all > [quoted text clipped - 10 lines] > > Hans Hi Sandy Thanks for your answer, but since i work on a german version i could not find some window that relates to the Window Freeze Panes... However: I found the print part and it works. You have a clue how to get me to the right window ?? hans > Select the Row under the last one that you want to remain visible and the > select Window > Freeze Panes [quoted text clipped - 16 lines] >> >> Hans Hi Hans, The *Window* that I was talking about was the drop-down Window menu on the Menu bar at the top of the screen. Mine starts off File, Edit, View, etc. SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > Hi Sandy > [quoted text clipped - 29 lines] >>> >>> Hans First, highlight Row 5 Then, from the Window Menu choose "Freeze Panes" If you're using Excel 2007, then the "Freeze Panes" option is located in the Window section of the VIEW tab. HTH, Elkar > Hi all > [quoted text clipped - 10 lines] > > Hans |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.