| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert a row
I recently installed Excell 2007 . I want to insert a row or column in a
converted file. When I try to insert either a row or column, I get the meesage "cannot shift object off sheet". The sheet is all data. I have not formatted it yet. What can I do to insert a row or column? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Insert a row
Press the F5 key, click on the Special button, check Objects and click on OK.
If there are any objects on the sheet they will be selected. You can simply delete it/them since you say there shouldn't be any. Then you should be able to insert "PACMAN" wrote: I recently installed Excell 2007 . I want to insert a row or column in a converted file. When I try to insert either a row or column, I get the meesage "cannot shift object off sheet". The sheet is all data. I have not formatted it yet. What can I do to insert a row or column? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unable to insert columns in excel, insert- columns (disabled) | Excel Discussion (Misc queries) | |||
| Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
| Insert Next? Or insert a variable number of records...how? | Excel Discussion (Misc queries) | |||
| How do I insert a reference to lookup and insert a name | New Users to Excel | |||
| How do I insert a comment when the Insert:Comment menu is greyed? | Excel Discussion (Misc queries) | |||
Linear Mode
