Find Archives - Xelplus - Leila Gharani

How to Lock & Unlock Cells in Microsoft Excel

Leila Gharani — Thu, 21 Apr 2022 08:00:00 +0000

There are many ways you can lock cells in Excel to protect others from overwriting your formulas and your data. I'll show you an easy way in this quick tutorial.

The post How to Lock & Unlock Cells in Microsoft Excel appeared first on Xelplus - Leila Gharani.

Top Excel Functions for Engineers

Leila Gharani — Thu, 23 Dec 2021 10:00:00 +0000

If you're a Mechanical Engineer, make sure you know these 10 Excel functions. Your work-life will become much easier once you learn these Excel formula combinations.

The post Top Excel Functions for Engineers appeared first on Xelplus - Leila Gharani.

Excel’s Find and Replace (surprising features)

Leila Gharani — Fri, 08 Feb 2019 23:46:00 +0000

Excel's Find and Replace can do much more than meets the eye. You can Find a specific formatting and replace it with another format. You can also highlight all the results found in the cells. This tutorial will uncover some surprising features of Excel's Find and Replace feature.

The post Excel’s Find and Replace (surprising features) appeared first on Xelplus - Leila Gharani.

Excel VBA FIND Function

Leila Gharani — Thu, 12 Jul 2018 07:55:00 +0000

Find out how to use the FIND function in Excel VBA. This can be more effective than looping through large data ranges. VBA also results in error if the value is not found. How can you overcome this error? Find out in the article.

The post Excel VBA FIND Function appeared first on Xelplus - Leila Gharani.