Split screen view will not allow selection of a single cell for a formula

Question

Split screen view will not allow selection of a single cell for a formula

KaminskH 11

Hello -

I am having an issue with the Excel split-screen view. When I try to enter a formula, I cannot select a single cell. Excel automatically extends the range and selects (what seems to me) a random number of cells, sometimes a column of cells, sometimes a quad of cells, etc.

I have tried to look up a solution but I haven't found anything similar to my issue. I do not have extended selection turned on. I do not have named cells or ranges.

Thoughts?

I am using Microsoft Office LTSC 64-bit Professional Plus 2021, Excel version 2108 (Build 14332.240400).

Viorel 122.6K Reputation points

2022-11-02T06:39:04.523+00:00

It seems to work. How to reproduce the problem in a new empty workbook?
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2022-11-02T07:06:30.007+00:00

Hi @KaminskH ,
Did you mean when you try to double click the cell and try to enter the formula, you cannot enter in the single cell but a range?
Could you provide a screenshot about your problem? So that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.
Linda.H 0 Reputation points

2023-09-13T06:52:03.92+00:00

in 2023, im using Windows 11 Pro and facing the same issues.

Is there any solution for this problem?
KaminskH 11 Reputation points

2023-09-13T12:18:13.6566667+00:00

@Linda.H , unfortunately, no. Perhaps bumping this up will get the attention of someone at Microsoft

3 answers

Your answer

Viorel 122.6K Reputation points

2022-11-02T06:39:04.523+00:00

It seems to work. How to reproduce the problem in a new empty workbook?
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2022-11-02T07:06:30.007+00:00

Hi @KaminskH ,
Did you mean when you try to double click the cell and try to enter the formula, you cannot enter in the single cell but a range?
Could you provide a screenshot about your problem? So that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.
Linda.H 0 Reputation points

2023-09-13T06:52:03.92+00:00

in 2023, im using Windows 11 Pro and facing the same issues.

Is there any solution for this problem?
KaminskH 11 Reputation points

2023-09-13T12:18:13.6566667+00:00

@Linda.H , unfortunately, no. Perhaps bumping this up will get the attention of someone at Microsoft

Answer 1

KaminskH 11

@Viorel and @Emi Zhang-MSFT

Just bumping to see if anyone else has encountered this problem.

Bren Lesaux - Public Services Procurement Canada 1 Reputation point

2022-12-09T19:14:34+00:00
Same issue.

I am using Excel version: Microsoft® Excel® for Microsoft 365 MSO (Version 2202 Build 16.0.14931.20648) 32-bit

Here is what I am doing.

I have enabled split screen - just one horizontal split.

I attempt to enter a formula in a cell on the righthand side of the split screen.

In entering the formula, I attempt to select a cell on left hand side of the split screen.

Excel attempts to select a range of cells

Sometimes it selects 3 cells, sometimes 6, 9 etc.

The only work around I have found is to remove the split screen.

Answer 2

KaminskH 11

@Viorel and @Emi Zhang-MSFT

I don't know if this is allowed but I recorded a video in Loom to show what is happening. It is short (2 minutes). I have tried this on at least 10 different spreadsheets and I have the same issue. I have used the split screen successfully for years so I don't know what I might have done differently to have this issue to occur.

https://www.loom.com/share/9809cd26002947299c069bab63b19d15

Answer 3

Angelica Jamaica Sabio (DHL PH) 1

Im encountering the same issue as well

Share via

Split screen view will not allow selection of a single cell for a formula

3 answers

Your answer