Thread
:
Excel sheet: scroll down, but leave first lines visible
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Sandy Mann
external usenet poster
Posts: 2,345
Excel sheet: scroll down, but leave first lines visible
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
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Hans F." wrote in message
...
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
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann