View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Felicity11 Felicity11 is offline
external usenet poster
 
Posts: 1
Default Lock a row at top for titles of columns?

On the Sheet page - I have tried to tell it to freeze row 1 but If I type in
a 1 then it
says "reference not valid" If I type a1; IV1 it says formula contains
errors - so how do I tell it to keep row 1 at the top?

"CyberTaz" wrote:

Hi bart-

Make sure you are in Normal View (_not_ in Print Preview) & go to FilePage
Setup. On the Sheet page specify what Row(s) to repeat at top.

HTH |:)

"bart dotzman" wrote:

Is there a way to lock the top row that contains the description of columns