Excel Tips and Tricks
How to wrap text in Excel
By default, Excel will cut off the characters that don't fit into a certain space. An alternative approach is wrapping the text to fully display it by increasing the cell height. In this guide, we’re going to show you how to wrap text in Excel. These...
How to create a gauge chart in Excel
A gauge chart (also known as dial or speedometer) is a type of visualization that typically displays one data field on a maximum-minimum scale. The fact that a single value is shown sets gauges aside from other visualizations.Although gauges are commonly used in...
How to use format painter in Excel
The Format Painter is the life saver when you need to copy only the formatting settings from one section to the other in your spreadsheet. In this guide, we’re going to show you how to use format painter in Excel. The best part is, this feature is...
How to add a custom button to Excel Ribbon
Ability to add a custom button helps you quick access to your macros or favorite actions directly from the Ribbon. The Ribbon was introduced in 2007 and made customizable with Excel 2010. So you can use this trick in all versions starting with 2010. This...
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...
Column Chart in Excel: Everything You Need to Know
A column chart is a graphic visualization of data using vertically placed rectangular bars (columns). Usually, each column represents a category, and all columns are drawn with a height proportional to the values they represent. The types of data column charts can...
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...