How do I freeze a row and column

  • Thread starter Thread starter james.smith.123
  • Start date Start date
J

james.smith.123

I would like to keep rows 1 and 2 static at the top and at the same time hold
column A. Column A is used for the description of an item then columns B to Z
contain the data, clearly when I get to column Z I can no longer see the
description for the data I am reading. At the same time there are a lot of
rows and I could do with seeing the upper heading as I am scrolling down the
data.
This may not be a freeze pane issue, so if anyone knows how to achieve this
your help would be much appreciated.
 
Select cell B3, Window>Freeze Panes

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Select one cell to the right, and one cell below, where you want to freeze
the view. This will freeze the view by both the x-axis and the y-axis.

Regards,
Ryan---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top