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?
- Array Formula
- Copy down formula with vba
- Loop in formula
- Three Leveled Formula
- Formula using range name in VBA code
- searching within formulas
- Populate Formula(Function) in rows
- Getting a formula to copy from inside VBA
- VBA Formula prob
- formula help but not vba please
- How to add several conditions for formula "SUMIF"
- combining formula
- VBA code to add values in two cells which have formulas
- VBA or array formula?
- Paste Formula help
- R1C1 Formula
- Stuck on copying formula from 1 sheet to another
- Named formula/Windows dialog boxes
- cells containing formula that refer to user-defined VBA function
- sum formula
- Manually creating a row outline with no formula anywhere
- Disabling Formulas, Not calculation
- Quotations in Formulas and strings