Do you know that you can use excel find – replace dialog to change cell formats?
Often we prepare a report or project plan and our boss or someone else in the team feels that all the red color cells need to change to blue or something similar, worry not, you can use find-replace (ctrl+h) to do this for you.
I have created a small video demo on how to do this, check it out yourself
If you are not able to see the video:
- Press Ctrl+h
- click on “Format…” button on “find what:” area and specify the source format
- click on “Format…” button on “replace with:” area and specify the target format
- Select “replace all” or “replace” depending on your need
- Smile, you have just automated a mechanical and boring task
4 Responses to “How windy is Wellington? – Using Power Query to gather wind data from web”
Breaking - Wind jokes at Chandoo
Kiwis sniffing for clues about blog post reason
It's confirmed: Wellington is windier than Uranus.
Acompanhando e aguardando ansiosamente a segunda parte.
[]s.
[Google translate]: Accompanying and eagerly awaiting the second part
hi chandoo,
i've tried using power query, however i face a rather weird problem. when i click on 'from web' option, the URL window does not show option for basic and advanced. thus i'm unable to form parameters in URL. how i can resolve this issue?