Lock and Unlock Cells in Excel

Lock & Unlock Cells in Microsoft Excel If you create spreadsheets for other people to use, you may have some experience with those people deleting or changing your formulas or other aspects of your workbook. Not only is it frustrating to have

Excel for Engineers

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.

Unprotect Cells by Color

Lock Cells & Protect Worksheet EVEN by Cell Color! This post will demonstrate how to lock and unlock cells.  That doesn’t sound like much to read about, but there’s a twist. We’re going to look at the basics of cell protection, which

Excel’s Find and Replace (surprising features)

Excel's Find and Replace (surprising features) One of the first features a Microsoft Word user discovers is the ability to search through a document, looking for a word, and replace the word with a different word. This is useful when you want