Convert Hijri to Gregorian

Excel supports Hijri and Umm-Al-Qura dates. This means we can display a Gregorian date in Hijri just by changing the Number Formatting of the corresponding cell. To display the Hijri equivalent of a Gregorian date, Right-click on the cell containing date > Format Cells > In the Format cells dialog, select Date from the options under Category…

Limit the Character length of a cell in Excel

Suppose, you want to restrict the number of characters that can be entered into an Excel cell. How will you solve this problem? The answer is Data Validation! Data Validation in Excel can be used to control the range, type & length of the data that can be entered into a cell. This blog post…

Overline text in Excel

This blog post is about 2 methods to create Overlined text in Excel. Method 1 Enter the text to be overlined into a cell. Here, I am using cell B3. Use the following formula to create the overlined version of the text in the cell B3. Make sure to turn on the Wrap Text option…

Pick a random value from a list in Excel

In this blog post, I will explain two Excel formulas that can be used to pick a random value from a List. Following is a list of 6 contestants for a particular game. For each round of the game, a player should be randomly selected from this list. Let’s see how to pick a random…

Different Methods to select Visible Cells only in Excel

In Excel, when we Copy-Paste from a dataset containing hidden rows, the hidden rows also get copied. In this blog post, we will see 3 different methods to select only the visible cells in Excel. Keyboard Shortcut Alt + ; is the shortcut to select visible cells in Excel. Select the cells and press Alt…

Copy and Paste into Visible cells in Excel

Filtered Rows and Hidden Rows In Excel, Rows that we hide manually and those Rows get hidden while applying Filters, work in different ways. When we copy-paste a value into the filtered cells they wonâ€™t be copied into the hidden cells. At the same time, if we hide some rows manually and copy-paste a value…

Different methods to Reverse a List in Excel

This article is about 3 different methods to Reverse a List in Excel. Following is a list of candidates applied for a job. Let’s see the different methods to reverse this list for scheduling the interview. 1. Reverse the list using a Helper column Create a helper column with sequential numbers (for example 1,2,3,..) adjacent…

Connect Google Sheets to Excel

In this blog post, I will explain the step by step procedure to Connect Google Sheets with Excel using Power Query. Once a spreadsheet in Google Sheets is connected with an Excel file, the changes made in the Source (Google Sheet) will be reflected in the Excel file at the expense of a single mouse…

Import Facebook Friends list into Excel

How to import Facebook Friends List to Excel is one of my most watched YouTube videos. In this blog post I will explain this technique step by step, for those whose prefer reading over video lectures. Facebook has an information section, where we can View or Download all those data related to our Facebook Account.…

Excel Formula to Insert Sheet Name into a Cell

Excel Formula to Insert Sheet Name into a Cell