Excel Unplugged

Tag Archives: Custom Cell Format

Simulating a “Tabular Form” Pivot Table Layout with Conditional Format

This is a follow up post on the final result of last week’s post Table.Join function in Power Query. So basically, we want to get from this To this Only by ...

Custom Cell Format You Must Know in Excel

Custom cell formats are a very important steppingstone to eternal happiness in Excel. And among all Custom Formats, one takes precedence for both, its usability and ...