 |
 | 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 / July 2007Problem inserting rows
I am working in Excel 2007 on a spreadsheet created in 2003 - when I try to insert a row (on any sheet) I get the message "cannot shift objects off sheet" and the OK button. Not sure what this means or how to correct it but I cannot insert any rows. Would appreciate your help. > I am working in Excel 2007 on a spreadsheet created in 2003 - when I try to > insert a row (on any sheet) I get the message "cannot shift objects off > sheet" and the OK button. Not sure what this means or how to correct it but > I cannot insert any rows. Are all rows under the area you're working with hidden? What's the last row number? I use to make my spreadsheets look nice by hiding all columns and rows that weren't in use but found you can't insert columns or rows if you do.  SignatureJordon Are all the rows formatted in some way? Or certain cells in every row? Even if the cells themselves are blank, if you've formatted them, it will cause a problem when trying to insert new rows. >I am working in Excel 2007 on a spreadsheet created in 2003 - when I try to >insert a row (on any sheet) I get the message "cannot shift objects off >sheet" and the OK button. Not sure what this means or how to correct it >but I cannot insert any rows. > > Would appreciate your help.
|
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.