Form Controls Archives - Xelplus - Leila Gharani

How to Use Checkboxes in Excel

Leila Gharani — Thu, 15 Jul 2021 08:00:00 +0000

Quickly learn how to create a checkbox in Excel. You can also easily create multiple checkboxes. It's important to learn how to use the outcome of the checkbox in formulas or conditional formatting - for example to get a strikethrough effect. Find out in this comprehensive tutorial.

The post How to Use Checkboxes in Excel appeared first on Xelplus - Leila Gharani.

Excel Conditional Formatting FUN Trick – Introducing the Mosaic Chart

Leila Gharani — Thu, 01 Aug 2019 10:15:00 +0000

Practice a lot of useful Excel techniques by setting up a fun game. You can create a mosaic puzzle in Excel with the help of the RANDBETWEEN function and features such as conditional formatting, custom number formatting, Excel backgrounds, row and column hiding and resizing, and Form Controls.

The post Excel Conditional Formatting FUN Trick – Introducing the Mosaic Chart appeared first on Xelplus - Leila Gharani.

Excel Dependent Combo Box Solves an Annoying Problem

Leila Gharani — Sat, 08 Dec 2018 01:41:00 +0000

Combo boxes are a good alternative to data validation drop-down lists in Excel. Learn how to create a dependent combo box in Excel. This combo box ends up solving an annyoing Excel "reset" problem.

The post Excel Dependent Combo Box Solves an Annoying Problem appeared first on Xelplus - Leila Gharani.

First Excel Hash Challenge between 6 MVPs

Leila Gharani — Tue, 04 Sep 2018 08:33:00 +0000

This Chick's Trouble is my recipe for Excel Hash. It includes the FREQUENCY & MAX functions, 3D Models & Form Controls. You'll be surprised what comes out...

The post First Excel Hash Challenge between 6 MVPs appeared first on Xelplus - Leila Gharani.