View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
kanejo kanejo is offline
external usenet poster
 
Posts: 4
Default 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