View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Freezing panes in Excel 2007?

Show A1 (to make sure column A and row 1 are visible)
then select B2
Then apply the freeze panes.

You'll be freezing all the rows above that active cell and you'll be freezing
all the columns to the left of that activecell.

Jon M wrote:

How do you freeze top row and 1st column in excel 2007 at the same time. The
current options seem to be either one or the other.

Thanks!


--

Dave Peterson