Custom Formatting Archives - PK: An Excel Expert

Transform Excel Data with Arrows & Color Coding with Custom Formatting

January 4, 2024October 10, 2026 PKComments Off

Introduction Are you struggling with visualizing budget variances in your Excel sheets? Well, worry no more! Our latest YouTube video, "Transform Excel Data with Arrows & Color Coding with Custom

Excel Tips and Tricks

Add KG to Your Numbers Instantly with This Simple Trick

January 2, 2024October 10, 2026 PKComments Off

In our latest, easy-to-follow article, we show you how to add KG to your numbers (or any unit!) in no time. Are you tired of your Excel data looking plain

Excel Tips and Tricks

Make Your Excel Data Invisible! Unbelievable Trick

January 1, 2024October 10, 2026 PKComments Off

Make Your Excel Data Invisible In this article, we will explain you how to Make Your Excel Data Invisible. Have you ever wondered how to keep your Excel data out

Excel Tips and Tricks

Auto Bullet Points in Excel with Custom Number Formatting

August 16, 2019October 10, 2026 PKComments Off

Auto bullet points in Excel are easy once you know the trick. Word, Outlook and PowerPoint have a Bullets button, but Excel doesn't, so most people type a symbol at

Excel Tips and Tricks

Arrow Symbols in Excel with Custom Formatting and Data Bars

May 6, 2019October 9, 2026 PKComments Off

Arrow symbols in Excel with custom formatting let you show a coloured up or down arrow right next to a percentage, without a single extra formula or helper column. In