 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2008In 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! 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 > 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. > 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 [quoted text clipped - 11 lines] > > 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 Tools>Protect Document and see if it's locked. --JP > Tried both of those, but to no avail. I get 37 rows on a sheet. > [quoted text clipped - 8 lines] > > HTH, > > JP It was not protected. You are giving me ideas I never thought of. > Unfortunately I'm at a computer where I can't test this, but maybe the > workbook/sheet is protected? Go to Tools>Protect Document and see if [quoted text clipped - 14 lines] > > > HTH, > > > JP Is the Scroll Lock on? --JP > 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! > Is the Scroll Lock on? > > --JP > > > It was not protected. You are giving me ideas I never thought of. Glad to hear you figured it out! --JP > 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!
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.