Make a Picture Transparent in Excel

Make a Picture Transparent

Excel can fade a picture so text or data shows through, which is useful for watermarks and dashboard backgrounds. Use the Transparency presets, or set an exact percentage in the Format Picture pane. WherePicture Format → Transparency Exact valueFormat Picture pane Works inMicrosoft 365, Excel 2021 and later Method 1: Transparency presets Select the picture … Read more

Convert Between Hijri and Gregorian Dates in Excel

Hijri and Gregorian Dates

Excel can show any date in the Hijri or Umm al-Qura calendar without changing the date itself. Use a number format to display it, or the TEXT function to write the Hijri date into another cell, next to the Gregorian one. Works inExcel 2010 and later, Windows. Excel for Mac supports fewer calendar options CalendarsHijri … Read more

Limit the Number of Characters in an Excel Cell

Limit Characters in a Cell

Data Validation can stop people typing more than a set number of characters into a cell, or insist on an exact length, such as a 10-digit mobile number or a 6-digit PIN code. WhereData → Data Validation → Text length Exact lengthCustom formula with LEN Works inAll versions Allow up to 5 characters Select the … Read more

Overline Text in Excel (3 Ways)

Overline Text in Excel

Excel has underline but no overline button. You can get the look with a formula that adds a line of underscores above the text, a combining overline character, or the Equation tool. FormulaREPT and CHAR(10) Excel 365UNICHAR(773) Exact lookInsert → Equation Method 1: Underscores above the text =REPT("_",LEN(B3))&CHAR(10)&B3Copy REPT writes one underscore per character, CHAR(10) … Read more

Select Visible Cells

Select Visible Cells Only

When rows are hidden, a normal copy also copies the hidden rows, and pasting can overwrite them. Press Alt + ; to select only the visible cells first, then copy or paste. ShortcutAlt + ; (Windows), Cmd + Shift + Z (Mac) MenuGo To Special → Visible cells only Filtered rowsAlready skipped automatically The problem … Read more

Matrix Digital Rain in Excel

Matrix Rain in Excel

Falling green code, like the film The Matrix, made with RANDBETWEEN, three conditional formatting rules and a tiny macro. A fun way to learn how MOD, ROW and conditional formatting work together. FunctionsRANDBETWEEN, MOD, ROW Formatting3 conditional formatting rules Macro8 lines, no Windows API The idea comes from Nitin Mehta of XLnControl (Engineers-Excel.com); I’ve added … Read more