Thread: Insert a row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey Duke Carey is offline
external usenet poster
 
Posts: 1,081
Default 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?