When i click on the formula bar - the text within it disappears! (Only from certain cells)

R

Revvy

New Member
Joined
Jul 11, 2022
Messages
5
Office Version
  1. 365
Platform
  1. Windows
Hi

This video will explain better than i could.

Basically when i click on the formula bar when im on certain cells, the text within it disappears. Meaning i cannot edit the formulas.

Video attached will show what i mean.


Thanks.
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Sort by date Sort by votes
Revvy said:
Hi

This video will explain better than i could.

Basically when i click on the formula bar when im on certain cells, the text within it disappears. Meaning i cannot edit the formulas.

Video attached will show what i mean.


Thanks.
Click to expand...
The video shows the first few cells working correctly, allowing me to edit the formulas, the others however disappear as so as i click on the formula box.
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question
Exclude Formula/Calculation based on status
Replies
1
Views
154
awoohaw
awoohaw
Artik
  • Solved
Disappearance of the rectangle when the Timer finishes.
Replies
6
Views
355
Artik
Artik
X
  • Question
Formula bar displaying SUM formula, but not its arguments
Replies
4
Views
295
KRice
K
U
  • Solved
Transfer data but not rows with a certain blank cell
Replies
2
Views
265
UTB
U
F
  • Question
AverageIF that contain a text for visible/filtered cells only
2
Replies
16
Views
603
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,215,409
Messages
6,124,743
Members
449,186
Latest member
HBryant

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top