In Excel 2003, the rows only go halfway down the page when I do a Page
Preview and the right sidebar won't move any further down. I would like to
add more rows. I tried moving the page break insert, but it didn't change
the # of rows. Help!

The rows might be hidden or the pane frozen. Check the Window menu, if
the pane is not frozen it should say "Freeze Panes". If it says
"Unfreeze Panes" that means you can scroll but you won't be able to
see certain rows.

If you press Ctrl-A, rightclick a cell and then select "Unhide" it
will unhide any hidden cells.


HTH,
JP

On Apr 10, 4:53*pm, kanejo wrote:
In Excel 2003, the rows only go halfway down the page when I do a Page
Preview and the right sidebar won't move any further down. *I would like to
add more rows. *I tried moving the page break insert, but it didn't change
the # of rows. *Help!

Tried both of those, but to no avail. I get 37 rows on a sheet.

"JP" wrote:

The rows might be hidden or the pane frozen. Check the Window menu, if
the pane is not frozen it should say "Freeze Panes". If it says
"Unfreeze Panes" that means you can scroll but you won't be able to
see certain rows.

If you press Ctrl-A, rightclick a cell and then select "Unhide" it
will unhide any hidden cells.


HTH,
JP

On Apr 10, 4:53 pm, kanejo wrote:
In Excel 2003, the rows only go halfway down the page when I do a Page
Preview and the right sidebar won't move any further down. I would like to
add more rows. I tried moving the page break insert, but it didn't change
the # of rows. Help!

Unfortunately I'm at a computer where I can't test this, but maybe the
workbook/sheet is protected? Go to ToolsProtect Document and see if
it's locked.

--JP

On Apr 10, 6:17*pm, kanejo wrote:
Tried both of those, but to no avail. *I get 37 rows on a sheet. *



"JP" wrote:
The rows might be hidden or the pane frozen. Check the Window menu, if
the pane is not frozen it should say "Freeze Panes". If it says
"Unfreeze Panes" that means you can scroll but you won't be able to
see certain rows.

If you press Ctrl-A, rightclick a cell and then select "Unhide" it
will unhide any hidden cells.

HTH,
JP

It was not protected. You are giving me ideas I never thought of.


"JP" wrote:

Unfortunately I'm at a computer where I can't test this, but maybe the
workbook/sheet is protected? Go to ToolsProtect Document and see if
it' s locked.

--JP

On Apr 10, 6:17 pm, kanejo wrote:
Tried both of those, but to no avail. I get 37 rows on a sheet.



"JP" wrote:
The rows might be hidden or the pane frozen. Check the Window menu, if
the pane is not frozen it should say "Freeze Panes". If it says
"Unfreeze Panes" that means you can scroll but you won't be able to
see certain rows.

If you press Ctrl-A, rightclick a cell and then select "Unhide" it
will unhide any hidden cells.

HTH,
JP

Is the Scroll Lock on?

--JP

On Apr 11, 2:54*pm, kanejo wrote:
It was not protected. You are giving me ideas I never thought of.

Scroll lock was not on. The good news is I started fiddling around with VIEW
trying Normal, Task Pane, and Page Break Preview. After hitting "page break
preview", I went back to Normal and suddenly all the rows down to a normal
page break were available on the scroll bar. Anyway, thank you for your help
- you got me to try things I would not have tried on my own!
"JP" wrote:

Is the Scroll Lock on?

--JP

On Apr 11, 2:54 pm, kanejo wrote:
It was not protected. You are giving me ideas I never thought of.

Glad to hear you figured it out!


--JP


On Apr 12, 1:17*am, kanejo wrote:
Scroll lock was not on. *The good news is I started fiddling around with VIEW
trying Normal, Task Pane, and Page Break Preview. *After hitting "page break
preview", I went back to Normal and suddenly all the rows down to a normal
page break were available on the scroll bar. *Anyway, thank you for your help
- you got me to try things I would not have tried on my own!