In this tutorial we are going to look at two methods of labeling or numbering accounts, locations, inventory, etc. using IF statements and Custom Formatting to count the frequency in a list or label the items in a sequence.
Tag Archives | Custom Formatting
Here is a clever way to display Yes or No instead of the values for your PivotTable…..
Here is a way to create a specialized list of labels using custom formatting and avoiding a lot of extra typing…..
Here is an option in Excel that allows you to fill the entire width of your cell with whatever you type into it…..
Here is how you can use custom formatting in Excel to fill the balance of your cell with a character…..
Sometimes you need to label the result of a function, but have no where to add it. Here’s an option…..