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
 
I know how to use macros. Do I just run this from the module of any open
workbook?
 
Yes

Open a new workbook
Paste the sub in a module and run it
Close the workbook without saving it
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert options 1
Inserting a Copied Row inside a table 6
Inserting cells (shift cells right) using macro 0
insert a line 1
Right Click Insert - Office XP 2
Right Click in Office XP 3
Why no "insert copied cells"? 1
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1

Back
Top