How to Add Comma in Excel

How to Add Comma in Excel

This article will explain how to add a comma in Excel using the ampersand (&) operator or built-in functions.

Sort by color

sort-by-color-in-excel

This article explains how to sort by color in Excel using conditional formatting, filter function, or VBA automation. How to sort by color in Excel Here are the steps to sort by color: #1: Use the custom sort 1. Select your data range, which contains three columns. If you prefer using the shortcuts instead of … Read more

Fill cell with RGB color

Fill cell with RGB color background in Excel

This tutorial will show you how to fill a cell or a range using RGB color in Excel to create a gradient scale.

How to swap cells in Excel

how to swap cells in excel

Today’s tutorial will show how to swap cells in Excel (adjacent and non-adjacent) using a few clicks or a small VBA macro. Swapping cells is a fast and effective time-saving trick; you need only two clicks to perform it instead of using the usual copy-pasting or move operations. This guide is a part of our … Read more

Show Protected Cells

show-protected-cells-using-conditional-formatting

This tutorial will explain how to show protected cells in Excel using conditional formatting, Microsoft Inquiry, or Search and Replace. How to show protected cells in Excel using conditional formatting? Steps to highlight protected cells in Excel: Select the entire Workbook Create a new conditional formatting rule Define a formula: =CELL(“protect”, A1)=0 Explanation: It’s easy … Read more

Color combinations for Dashboards

color combinations for dashboards and palettes

As developers, it’s a challenge to pick the right color combinations for Dashboards. This guide shows the best color schemes and palettes. Before we dive deep into the sea of dashboards, let’s wait a minute! A carefully picked color combination provides a clean look and makes your key performance indicators easily readable. Because every developer … Read more