Resources
How to show named ranges that were made hidden using VBA
Hidden named ranges can be tricky to find and work with. This article will guide you through how you can show named ranges that were hidden using VBA.How to show named ranges that were hiddenNamed ranges are objects in a workbook's Names collection and...
How to insert a degree symbol in Excel
The degree symbol (°) typically indicates temperature measurement, the magnitude of angles in geometry, and diminished chords in music. However, standard keyboards don't have a button for this useful symbol. In this article, we're going to show you 4...
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...