Make a picture transparent in Excel

In Microsoft Excel, we can set the Transparency level for pictures inserted into it. The following are the two methods to change the transparency of a picture in Excel. Method 1 Select the picture > Go to the Picture Format tab > In the group called Adjust, click on the drop-down menu for Transparency Make a picture transparent in Excel 7 Transparency levels…

Show Formulas in Excel

3 different methods to display formulas used in an Excel worksheet. Method 1 Go to the Formulas tab in the Excel ribbon, Click on Show Formulas Once you click on this button, every cell in the worksheet will display the formula used in that cell, instead of the resulting value. To turn off of this…

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…

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…