Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
In Excel, how do I add more rows to the worksheet? Tried moving .
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! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
In Excel, how do I add more rows to the worksheet? Tried moving .
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! |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
In Excel, how do I add more rows to the worksheet? Tried movin
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! |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
In Excel, how do I add more rows to the worksheet? Tried movin
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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
In Excel, how do I add more rows to the worksheet? Tried movin
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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
In Excel, how do I add more rows to the worksheet? Tried movin
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving data from multiple rows to single rows | Excel Worksheet Functions | |||
Excel comments moving on the worksheet | Excel Discussion (Misc queries) | |||
How to stop the cursor moving the whole excel worksheet | Excel Discussion (Misc queries) | |||
Moving rows | Excel Discussion (Misc queries) | |||
moving rows | Excel Discussion (Misc queries) |