Right Click and Insert is greyed out in popup

domineaux

New Member
Joined
Mar 7, 2008
Messages
26
Using Excel 2007 w/Win Vista Ultimate 64bit

When I right click on top bar to insert a column the Insert is greyed out.
When I right click on the left side bar to insert a row the Insert is greyed out.

I must have turned off the insert feature at some point.

If I go directly to a cell the insert feature works.

Could sure use help on this, cannot work with sheets as is.

I've ran the rounds of Google, and haven't found anything to fix.
 

domineaux

New Member
Joined
Mar 7, 2008
Messages
26
I just scrutinized the sheet carefully.

I have several columns where text is runnning past 255 characters in some of the rows. I understand you can have formulas that can extend to appx 32K so I would think text could do the same.

This is the only thing I can think of that is unique on this worksheet.

The copy/paste command has failed to work when I had to many tabs open in a the web browser when I was working with a website.
 

domineaux

New Member
Joined
Mar 7, 2008
Messages
26
Yep! when I made sure no cell with text characters exceeded 255 characters.

Voila! it fixed the insert problem.
 

Forum statistics

Threads
1,081,556
Messages
5,359,557
Members
400,534
Latest member
michaella

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top