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
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.
Switch Data in Columns to Rows Transpose or Unpivot (Some) Fields This will be another tutorial on transposing horizontal data into vertical data. But this technique has a twist. No, wait! TWO twists! Twist 1: we don’t want to change ALL the
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) 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