How to wrap text in Excel

How to wrap text in Excel

by | Jan 17, 2019

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 methods...

How to create a gauge chart in Excel

by | Jan 16, 2019

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

How to use format painter in Excel

by | Jan 14, 2019

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 supported by pretty...
How to add a custom button to Excel Ribbon

How to add a custom button to Excel Ribbon

by | Jan 9, 2019

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 article shows...
How to show named ranges that were made hidden using VBA

How to show named ranges that were made hidden using VBA

by | Dec 25, 2018

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 they have...
How to insert a degree symbol in Excel

How to insert a degree symbol in Excel

by | Dec 21, 2018

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

by | Dec 21, 2018

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...

Column Chart in Excel: Everything You Need to Know

by | Dec 19, 2018

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

How to format numbers in Excel with millions separators

by | Dec 18, 2018

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...