Insert rows greyed out possible reasons?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ordinary spreadsheet - using it as a address book name address etx
I was able to use Insert rows once however never again. Every time I go to
use the function its greyed out whether I use the icon bar or the right click
way. I have highlighted cell and tried. I have highlighted row and tried.
I am baffled.

Also where the heck is the Old "File" function

Using Vista and Excell 2007 In Windows Office
 
Sounds like the Worksheet/workbook is protected.
Try:

Tools-Protection-Unprotect...

HTH,
Paul
 
Possibly either a protected worksheet or a filter has been applied to the
worksheet.

try Data->Filter->Show All and then see if you can insert rows
 

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

Series fill only copying and fill series greyed out 1
Grey bar at left side of worksheet 2
Insert Rows option greyed out 0
Right click mouse menu for insert does not work 2
Word icon greyed 1
External Data Toolbar permanently greyed out. 7
Data Sort Option greyed. 1
Insert Worksheet "greyed out" 2

Back
Top