You hide the rows first then apply Freeze Panes


Gord Dibben MS Excel MVP

On Fri, 19 Oct 2007 16:15:00 -0700, JR Hester
wrote:

Well Blow me down. I would NEVER have thought of that one. In case I want to
do that sometime how do you frezze panes to PREVENT rows from displaying? I
have always used Freeze panes to force rows or columns to always be dispalyed.

That was absolutely teh right answer

"Ron Coderre" wrote:

It sounds like the panes may be frozen....

From the Excel Main Menu:
Select: Window
.....If there's an UNFREEZE panes option....Select it.

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"JR Hester" wrote in message ...
Excel Xp on Win XP

I am working with series of worksheets prepared by an indivuidual no longer
with our organization, so I can't ask.

It appears that the top 3 rows have been hidden, because the top row of
appearing on each sheet was/is row #4. I also positioned IP into cell A4 and
used uparrow, which indicated I was in cell A3, A2, A1 respectively each time
I pressed the uparrow key. Also during this time, although I could not see
teh actual rows onscreen, the contents of these cells displayed in the
formula bar.

I need to unhide these rows so that I can delete them. I need to import data
from these spreadsheets into an Access database, and need my 4th row(
contains field names) to be top row( #1). I can't find a way to select rows
1, 2 and 3. There has to be a trick for selecting these top 3 rows that I
have not discovered.

Who can light my torch so I can see these hidden rows. Thanks in advance
for your fantastic assistance.