Resources
How to insert a check mark in Excel
A check mark is the universal character for confirmed tasks and is widely used in managing lists. Seeing how commonly it's used in organizing ourselves, you would think that there should be a keystroke for this! In this article, we listed 5 methods you can use to to...
How to format numbers in Excel with millions separators
Number Formatting feature in Excel allows modifying the appearance of cell values, without changing their actual values. Currency formatting with dollar signs ($), or highlighting negative values with red are common examples. Another advantage of this...
How to format numbers in thousands in Excel
Number Formatting feature in Excel allows modifying the appearance of cell values, without changing their actual values. Currency formatting with dollar signs ($), or highlighting negative values with red are common examples. Another advantage of this...
How to delete Excel shapes (AutoShapes) using VBA
Excel, just like other Office products, supports AutoShapes. Although Excel shapes are nice to have for presentation purposes, getting rid of them may become time consuming if your workbook is cluttered with them. This article shows you how to delete Excel shapes...
How to make Excel delete all pictures
Excel, just like other Office products, supports inserting pictures of various formats into your workbooks. However, deleting them may be time consuming in large workbooks if you're trying to find and delete every single image manually. Let us show you how...
How to remove hyperlink in Excel quickly using VBA
Excel, just like other Office products, can detect URLs and email addresses, and turn them automatically into hyperlinks. While this can usually speed things up when creating workbooks, they can become nuisance when you don't want them to be clickable...
How to make Excel update links using VBA
Excel doesn't automatically update any external links in your workbooks and this can become a hassle if it's something happening frequently. In this article, we're going to show you how to make Excel update links automatically using VBA. How to make Excel...
How to delete named range Excel using VBA
Managing and removing named ranges in Excel can be a challenging task as you would have to do this one by one for each field. We're going to show you how to delete named range Excel using VBA with one click.How to delete named range ExcelEach named range...
How to allow Excel uppercase characters only
It’s often a good idea to use Data Validation feature to limit user errors and streamline data entry process. In addition to built-in rules, like size of a number or length of a text, you can define your own rules in a Custom fashion. Let us show you how...