A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Alt - I - R" problem



 
 
Thread Tools Display Modes
  #1  
Old May 3rd, 2005, 12:57 AM
Doug
external usenet poster
 
Posts: n/a
Default "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  
Old May 3rd, 2005, 01:24 AM
Gord Dibben
external usenet poster
 
Posts: n/a
Default

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  
Old May 3rd, 2005, 01:38 AM
Dave Peterson
external usenet poster
 
Posts: n/a
Default

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  
Old May 3rd, 2005, 01:39 AM
Doug
external usenet poster
 
Posts: n/a
Default

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  
Old May 3rd, 2005, 02:12 AM
Doug
external usenet poster
 
Posts: n/a
Default

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  
Old May 3rd, 2005, 12:39 PM
Dave Peterson
external usenet poster
 
Posts: n/a
Default

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  
Old May 3rd, 2005, 12:40 PM
Dave Peterson
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Rec. Nav. problem cause by checkboxes/Conditional formatting Shelbygt22 General Discussion 0 March 22nd, 2005 05:59 PM
Strange problem with different networks. Adam General Discussion 1 March 13th, 2005 11:17 PM
IE6 & Outlook Problem (Strange Problem)! KW Outlook Express 4 February 1st, 2005 09: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


All times are GMT +1. The time now is 07:19 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.