Row 3 is the first one shown. I tried to unhide them but it didn't work. When
I insert new rows they still start with row 3. Where are the missing 1st and
2nd rows?

Bill R wrote:
Row 3 is the first one shown. I tried to unhide them but it didn't work. When
I insert new rows they still start with row 3. Where are the missing 1st and
2nd rows?

Hi Bill,

Could be the sheet's scroll area property is set at $3:$65536.

To check that out...

1. Right click the sheet tab
2. Select View code from the popup. This takes you to the VB editor.
3. In the VB editor go View|Properties Window then look for ScrollArea
in the left column of the properties window. If there is an address in
the right column then just delete it.
4. Press Alt + F11 to get back to Excel.

Ken Johnson

Try:

<Window <Unfreeze Pane
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bill R" wrote in message
...
Row 3 is the first one shown. I tried to unhide them but it didn't work.
When
I insert new rows they still start with row 3. Where are the missing 1st
and
2nd rows?

The ScrollArea property was blank so that didn't work.

"Ken Johnson" wrote:

Bill R wrote:
Row 3 is the first one shown. I tried to unhide them but it didn't work. When
I insert new rows they still start with row 3. Where are the missing 1st and
2nd rows?

Hi Bill,

Could be the sheet's scroll area property is set at $3:$65536.

To check that out...

1. Right click the sheet tab
2. Select View code from the popup. This takes you to the VB editor.
3. In the VB editor go View|Properties Window then look for ScrollArea
in the left column of the properties window. If there is an address in
the right column then just delete it.
4. Press Alt + F11 to get back to Excel.

Ken Johnson

Tried to unfreeze panes also but that didn't work. Any other ideas?

"RagDyer" wrote:

Try:

<Window <Unfreeze Pane
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bill R" wrote in message
...
Row 3 is the first one shown. I tried to unhide them but it didn't work.
When
I insert new rows they still start with row 3. Where are the missing 1st
and
2nd rows?

Another thought:

When you "hide" a row, XL changes the height to 0, so it (XL) then knows to
enable the "unhide" command and return the row to it's original height.

However, if the row height is set to say a minimum of 0.25, even though it's
not visible, the "unhide", doesn't work.

So ... *Go To* Row1, and change the height to the default 12.75, then *Go
To* Row2 and do the same.

Hit <F5
Type
A1
<Enter
Then, <Format <Row <Height,
And enter the default 12.75,
Then <OK

Does *THAT* work?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bill R" wrote in message
...
Tried to unfreeze panes also but that didn't work. Any other ideas?

"RagDyer" wrote:

Try:

<Window <Unfreeze Pane
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bill R" wrote in message
...
Row 3 is the first one shown. I tried to unhide them but it didn't
work.
When
I insert new rows they still start with row 3. Where are the missing
1st
and
2nd rows?

It is most likely to be that they are hidden, but they could also have
been set with zero height - highlight the whole sheet by clicking the
button at the intersection of the row and column identifiers, then
click Format | Row | Autofit (you could also try Format | Row | Unhide
again).

Hope this helps.

Pete

Bill R wrote:
Tried to unfreeze panes also but that didn't work. Any other ideas?

"RagDyer" wrote:

Try:

<Window <Unfreeze Pane
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bill R" wrote in message
...
Row 3 is the first one shown. I tried to unhide them but it didn't work.
When
I insert new rows they still start with row 3. Where are the missing 1st
and
2nd rows?

Didn't work. Thanks anyway.

"Pete_UK" wrote:

It is most likely to be that they are hidden, but they could also have
been set with zero height - highlight the whole sheet by clicking the
button at the intersection of the row and column identifiers, then
click Format | Row | Autofit (you could also try Format | Row | Unhide
again).

Hope this helps.

Pete

Bill R wrote:
Tried to unfreeze panes also but that didn't work. Any other ideas?

"RagDyer" wrote:

Try:

<Window <Unfreeze Pane
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bill R" wrote in message
...
Row 3 is the first one shown. I tried to unhide them but it didn't work.
When
I insert new rows they still start with row 3. Where are the missing 1st
and
2nd rows?

Wow, that didn't work either. It is as if those two rows have been moved to
somewhere else in the workbook but I have looked at all the other sheets and
I cant find them.

"RagDyer" wrote:

Another thought:

When you "hide" a row, XL changes the height to 0, so it (XL) then knows to
enable the "unhide" command and return the row to it's original height.

However, if the row height is set to say a minimum of 0.25, even though it's
not visible, the "unhide", doesn't work.

So ... *Go To* Row1, and change the height to the default 12.75, then *Go
To* Row2 and do the same.

Hit <F5
Type
A1
<Enter
Then, <Format <Row <Height,
And enter the default 12.75,
Then <OK

Does *THAT* work?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bill R" wrote in message
...
Tried to unfreeze panes also but that didn't work. Any other ideas?

"RagDyer" wrote:

Try:

<Window <Unfreeze Pane
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bill R" wrote in message
...
Row 3 is the first one shown. I tried to unhide them but it didn't
work.
When
I insert new rows they still start with row 3. Where are the missing
1st
and
2nd rows?

I found the problem. It was as simple as selecting row 3 and then using my
arrow key to move up. Now I feel really stupid. Thanks for all of the help.

"Pete_UK" wrote:

It is most likely to be that they are hidden, but they could also have
been set with zero height - highlight the whole sheet by clicking the
button at the intersection of the row and column identifiers, then
click Format | Row | Autofit (you could also try Format | Row | Unhide
again).

Hope this helps.

Pete

Bill R wrote:
Tried to unfreeze panes also but that didn't work. Any other ideas?

"RagDyer" wrote:

Try:

<Window <Unfreeze Pane
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bill R" wrote in message
...
Row 3 is the first one shown. I tried to unhide them but it didn't work.
When
I insert new rows they still start with row 3. Where are the missing 1st
and
2nd rows?