J
jr
what you describe happens and it's a nuisance.
Frequently, formatting is perfectly functional in one
cell but not in others. Two quick fixes:
1) find a cell ANYWHERE in your worksheet and try to use
the format. SOME WILL. Then copy that format to the
desired cell.
2) put your favorite formatting operations (eg...
background colors, decimals, etc.) on the taskbar so
that they're selectible from icons.
Frequently, formatting is perfectly functional in one
cell but not in others. Two quick fixes:
1) find a cell ANYWHERE in your worksheet and try to use
the format. SOME WILL. Then copy that format to the
desired cell.
2) put your favorite formatting operations (eg...
background colors, decimals, etc.) on the taskbar so
that they're selectible from icons.