Forum Discussion

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
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.

SergeiBaklan

Diamond Contributor

May 05, 2024

Jimbo2024

Means you selected that range.

How do you move the cursor, by mouse or by keyboard. Do you keep pushed any mouse or keyboard button?

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
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.
- SergeiBaklan
  Diamond Contributor
  May 11, 2024
  PeterBartholomew1
  
  That's with keyboard. With mouse Ctrl is enough.
  
  How to Select Non-adjacent cells in Excel? (4 Easy Ways) (trumpexcel.com)
SergeiBaklan
Diamond Contributor
May 10, 2024
Jimbo2024

But mouse button is pressed?