How to hide named ranges using VBA

How to hide named ranges using VBA

You might want to hide the named ranges in your workbook to prevent your users to tamper with your calculations. In this article, we’re going to show you how to hide named ranges in Excel using VBA.   How to hide named ranges using VBA Named ranges are objects...
How to insert a degree symbol in Excel

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

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...
How to format numbers in thousands in Excel

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 feature is the...