Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert rows greyed out possible reasons?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert rows greyed out possible reasons?
Sounds like the Worksheet/workbook is protected.
Try: Tools-Protection-Unprotect... HTH, Paul "Mysticmuse" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert rows greyed out possible reasons?
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 -- Rich "Mysticmuse" wrote: 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 |
#4
|
|||
|
|||
5 Reasons for greyed out
Hi,
I cam across similar situation in terms of insert button and identified 5 reasons that could be the probable reason. detailed Information is available in the below website with how to resolve it. Excel Insert Button Greyed Out? 5 Solutions (with Images) Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert new worksheet option is greyed out. Why? | Excel Discussion (Misc queries) | |||
Insert Rows option greyed out | Excel Discussion (Misc queries) | |||
Insert worksheet is greyed out, is there an option to turn it on? | Excel Worksheet Functions | |||
Why are the Edit, Insert and Format menus greyed out in Excel? | Excel Discussion (Misc queries) | |||
Why is the menu item "Insert - Name" greyed out? | Excel Discussion (Misc queries) |