Right Click Insert in Excel

  • Thread starter Thread starter ibeetb
  • Start date Start date
I

ibeetb

When I right click in office XP excel and go to Insert, I no longer get the
box that asks if I want to shift cells down or insert a row or column. Is
this a loss of functions in XP or do I have a bug in my Office XP?
 
Hi ibeetb

You only get this if you right click on a cell.
It will not happen if you right click on a row number
 
Mmmm, Strange

Try to reset your cell menu

Sub ResetCellmenu()
With Application.CommandBars("Cell")
.Reset
.Enabled = True
End With
End Sub

If you not know how to use this macro post back
 
Yes

Open a new workbook
Paste the sub in a module and run it
Close the workbook without saving it
 
Back
Top