Forum Discussion

Jimbo2024's avatar
Jimbo2024
Copper Contributor
May 05, 2024
Solved

Turning off an Excel feature accidentally activated

I accidentally activated an Excel feature which causes the following result: When I move my cursor from the activated cell to another location on the page, the feature creates a large grey square the...
excel
  • PeterBartholomew1's avatar
    PeterBartholomew1
    May 11, 2024

    Jimbo2024 

    I think the process for selecting a range is 

    1. Select the top/left cell

    2. Click F8

    3. Click on the bottom/right cell to select the range

    4. Press Enter to commit the formula and clear the toggle setting

     

    Note: multiple range arguments can be inserted within a function because moving to the next parameter using "," will also clear the toggle.

Jimbo2024's avatar
Jimbo2024
Copper Contributor
May 10, 2024
I move my cursor by mouse. No, I do not keep any keyboard button switched on except NumLock a lot and occasionally CapsLock. The problem vanished as mysteriously as it arose but I would like to know how to activate the ability to "select a range". A baby question, I know. I will just look that up myself.
Jimbo2024
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
May 11, 2024

Jimbo2024 

I think the process for selecting a range is 

1. Select the top/left cell

2. Click F8

3. Click on the bottom/right cell to select the range

4. Press Enter to commit the formula and clear the toggle setting

 

Note: multiple range arguments can be inserted within a function because moving to the next parameter using "," will also clear the toggle.

Resources