Author: Chandoo

My name is Chandoo. I am going to make you awesome in Excel, VBA, Dashboards, Power BI & Power Pivot and answering your questions. I live in Wellington, New Zealand. It is a beautiful, small city on the southern edge of the world. I run my own Excel Consulting & Training business from here. I am married to my college sweet-heart, Jo. We have 2 kids – twins. They are 10 years old now. They are busy creating new worlds with lego bricks or playing or learning. We (Jo &I) are busy with cooking, eating, walking, talking and reading.

Formatting Paste Special

What is in this lesson?

  • Make phone numbers readable
  • Make joining date readable
  • Currency format sales and profits
  • Understand how formats work, examples
  • Conditional format codes – examples
  • Hide a value without really removing it
  • Make the entire table readable
  • Copy and paste formats
  • Column widths and row heights
  • Format Painter, Paste Special
  • Freezing the top row of table

Continue reading “Formatting Paste Special”