Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

I thought I had run across most of the silly things Excel does but this is new

to me.

I open excel and it opens a blank ss.

I type aaa in cell A1 (all is normal so far)

I type bbb in cell A2 (all is normal so far)

I click in cell A1

The formula bar is blank

I double click in cell A1

The edit in cell opens normally but the formula bar is still blank

When I start changing the text in A1 the text in the formula bar appears

If I double click A2 the formula bar is blank

If I click in the formula bar I can delete a character (which is an empty

space) and the characters after that character appear but not those before it.

This is driving me crazy.

It was indeed weird. My other PC worked OK.

I cured it but don't understand why. I changed the Display

Properties/Appearance setting from silver to blue(default) and then back to

silver. That fixed it so it was a windows glitch rather than an Excel one.

Let's hope the fix sticks.

I do not think that it should had anything to do with the view setting of the

windows. Have you tried to repair office xp, by going through installed

software, and please also check that "C:\Documents and Settings\(user

name)\Application Data\Microsoft\Excel\XLSTART" folder is empty.

It was the Windows setting - I don't know how that got corrupted. I had tried

the Detect and Repair - it made no difference. I have several things in

XLStart but I know what they all are and have had them a while.

Didn't find what you were looking for?
Find more on Blank Formula bar
Or get search suggestion and latest updates.

Related Topics:

- Ctrl+Shift+Arrow Fails To Select Cells When Used in Formula Bar
- clearing cells value without deleting the formula I've made in cell from excel formula , HOW?
- Loop in formula
- Copy down formula with vba
- Array Formula
- R1C1 Formula
- Paste Formula help
- VBA or array formula?
- VBA code to add values in two cells which have formulas
- combining formula
- How to add several conditions for formula "SUMIF"
- VBA Formula prob
- Getting a formula to copy from inside VBA
- Populate Formula(Function) in rows
- searching within formulas
- Formula using range name in VBA code
- Three Leveled Formula
- formula help but not vba please
- Named formula/Windows dialog boxes
- Disabling Formulas, Not calculation
- Stuck on copying formula from 1 sheet to another
- cells containing formula that refer to user-defined VBA function
- sum formula
- Manually creating a row outline with no formula anywhere
- Constructing Address formulas