Excel Formatting : Advance



1. To get "-" instead of "0" in the excel sheet 

Go to home then Cell Style and then do New Rule 

> Custom, Write instead of General 0;-0;"-"

2. To wrap the text in row 

Ctrl+A  > then >  Alt+H+W

Comments

Post a Comment

Popular posts from this blog

Word Formatting

Image
Formatting word documents takes eternity until you learn it ! How to remove my name from Author ? By clicking file , then on Info   Inspect Document > Inspect Document, uncheck Comments, Revisions and Versions  Then Inspect and Remove Document Propoerties and Personal Information Note : If it is track changes mode then the changes by different Author will become one and just show tracj changes rather than changes by different authors.
Read more