If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Alt - I - R" problem
About two weeks ago when I was trying to insert a row I found that my "Alt -
I - R" function was not working. After asking around, I found this has happened to other people. Can anyone help tell me what I have done or how to fix this problem...so that I can use "Alt - I - R" in order to insert a row? Thanks, Doug |
#2
|
|||
|
|||
Doug
If the worksheet protection is enabled ALT + I + R along with many other commands will not be available. Check at ToolsProtection. Gord Dibben Excel MVP On Mon, 2 May 2005 16:57:04 -0700, "Doug" wrote: About two weeks ago when I was trying to insert a row I found that my "Alt - I - R" function was not working. After asking around, I found this has happened to other people. Can anyone help tell me what I have done or how to fix this problem...so that I can use "Alt - I - R" in order to insert a row? Thanks, Doug |
#3
|
|||
|
|||
Where does it break?
If it breaks with the alt-i, hit alt-i again and see if you get another menu item highlighted. If you hit alt-i a few times, you may be able to see the highlighted options toggle on and off. If there are two items that have the same accelerator key, the excel won't know which one you want. (If you hit enter with one highlighted, you may be able to see where it is, too.) Doug wrote: About two weeks ago when I was trying to insert a row I found that my "Alt - I - R" function was not working. After asking around, I found this has happened to other people. Can anyone help tell me what I have done or how to fix this problem...so that I can use "Alt - I - R" in order to insert a row? Thanks, Doug -- Dave Peterson |
#4
|
|||
|
|||
Gord - Thank you for the reply, but that is not the problem
"Gord Dibben" wrote: Doug If the worksheet protection is enabled ALT + I + R along with many other commands will not be available. Check at ToolsProtection. Gord Dibben Excel MVP On Mon, 2 May 2005 16:57:04 -0700, "Doug" wrote: About two weeks ago when I was trying to insert a row I found that my "Alt - I - R" function was not working. After asking around, I found this has happened to other people. Can anyone help tell me what I have done or how to fix this problem...so that I can use "Alt - I - R" in order to insert a row? Thanks, Doug |
#5
|
|||
|
|||
Dave -
Thank you for the message....it does break after alt-i (the row and column functions are greyed out and cannot be selected). I tried alt-i several times with no luck toggling the row or column function on. Doug "Dave Peterson" wrote: Where does it break? If it breaks with the alt-i, hit alt-i again and see if you get another menu item highlighted. If you hit alt-i a few times, you may be able to see the highlighted options toggle on and off. If there are two items that have the same accelerator key, the excel won't know which one you want. (If you hit enter with one highlighted, you may be able to see where it is, too.) Doug wrote: About two weeks ago when I was trying to insert a row I found that my "Alt - I - R" function was not working. After asking around, I found this has happened to other people. Can anyone help tell me what I have done or how to fix this problem...so that I can use "Alt - I - R" in order to insert a row? Thanks, Doug -- Dave Peterson |
#6
|
|||
|
|||
And you're sure that the worksheet is not protected?
What version of excel are you using? In xl2k and below, you can't insert columns in a range that is filtered (without removing that filter). I'm not sure if the option is greyed out, though. === Some questions... Does this happen on all your workbooks--or just one? Does it happen in all the worksheets in that workbook or just one? If you start excel in safe mode: close excel windows start button|run excel /safe does it work ok? === How about tools|Customize|toolbars tab select worksheet menu bar click reset Did that help? === And you're positive that alt-i doesn't swap between two different options??? Doug wrote: Dave - Thank you for the message....it does break after alt-i (the row and column functions are greyed out and cannot be selected). I tried alt-i several times with no luck toggling the row or column function on. Doug "Dave Peterson" wrote: Where does it break? If it breaks with the alt-i, hit alt-i again and see if you get another menu item highlighted. If you hit alt-i a few times, you may be able to see the highlighted options toggle on and off. If there are two items that have the same accelerator key, the excel won't know which one you want. (If you hit enter with one highlighted, you may be able to see where it is, too.) Doug wrote: About two weeks ago when I was trying to insert a row I found that my "Alt - I - R" function was not working. After asking around, I found this has happened to other people. Can anyone help tell me what I have done or how to fix this problem...so that I can use "Alt - I - R" in order to insert a row? Thanks, Doug -- Dave Peterson -- Dave Peterson |
#7
|
|||
|
|||
Never mind about the alt-i swapping between options. I reread your response and
you said that the options show up, they're just disabled. Doug wrote: Dave - Thank you for the message....it does break after alt-i (the row and column functions are greyed out and cannot be selected). I tried alt-i several times with no luck toggling the row or column function on. Doug "Dave Peterson" wrote: Where does it break? If it breaks with the alt-i, hit alt-i again and see if you get another menu item highlighted. If you hit alt-i a few times, you may be able to see the highlighted options toggle on and off. If there are two items that have the same accelerator key, the excel won't know which one you want. (If you hit enter with one highlighted, you may be able to see where it is, too.) Doug wrote: About two weeks ago when I was trying to insert a row I found that my "Alt - I - R" function was not working. After asking around, I found this has happened to other people. Can anyone help tell me what I have done or how to fix this problem...so that I can use "Alt - I - R" in order to insert a row? Thanks, Doug -- Dave Peterson -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Rec. Nav. problem cause by checkboxes/Conditional formatting | Shelbygt22 | General Discussion | 0 | March 22nd, 2005 04:59 PM |
Strange problem with different networks. | Adam | General Discussion | 1 | March 13th, 2005 10:17 PM |
IE6 & Outlook Problem (Strange Problem)! | KW | Outlook Express | 4 | February 1st, 2005 08:31 AM |
Reinstalling OE... | KAR | Outlook Express | 24 | August 21st, 2004 06:52 PM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |