Excel formatting on WP8

[MBY]

I know that Excel on WP is somewhat limited in its functionality. I'm not happy about that, but I accept it. I came across something truly puzzling recently, though. Once I edit a cell's formatting (data type, bold, font color, background color, etc.) I don't seem to be able to reset it to default. For fill color, for example, you have three options of colors, none of them white/blank. And you don't seem to be able to just uncheck that option.

Any suggestions?

 

[realwarder]

If you can clear the formatting, I cannot work it out and I spent a few minutes clicking and long pressing everything.

Clearly you are the first person in the world to try doing that as anyone who actually tried using it would want to clear the formatting!

 

[MBY]

Is there really no way to do this? It pretty much means that formatting of any kind in Excel is useless because you can't remove it.

 

[Batoloco]

Yeah, I am flummoxed as well. I cannot undo bold on a whole row. Also, after the 2nd or 3rd time I open the same file one column keeps reverting to date format no matter how many times I save it as currency; of course, I would like plain decimal but Excel doesn't allow it. What a strange situation, to have a shiite WP8.1 spreadsheet program when Android, iOS, and even my old IPaq 210 have a better program. WTF?! :unhappy:

 

[Apoc]

Does MS, have any plans on adding these and many more important functions to WP 8.1?

 

[xandros9]

Does MS, have any plans on adding these and many more important functions to WP 8.1?

the current Office hub has been neglected, but I believe they're working on a universal Office touch.

 

[Apoc]

the current Office hub has been neglected, but I believe they're working on a universal Office touch.

I just hope they do address the functions part of it, very soon.

 

[AG VK]

the current Office hub has been neglected, but I believe they're working on a universal Office touch.

Of course they are. Just like everything else.

 

[xandros9]

Of course they are. Just like everything else.

you know thats not true like you imply

 

[David P2]

Yeah, I am flummoxed as well. I cannot undo bold on a whole row. Also, after the 2nd or 3rd time I open the same file one column keeps reverting to date format no matter how many times I save it as currency; of course, I would like plain decimal but Excel doesn't allow it. What a strange situation, to have a shiite WP8.1 spreadsheet program when Android, iOS, and even my old IPaq 210 have a better program. WTF?! :unhappy:

Least ours is free... iOS users need an Office 365 subscription to use Office on their phones.

 

[tgp]

Least ours is free... iOS users need an Office 365 subscription to use Office on their phones.

Not anymore. Office is now free for iOS & Android.