Diabild scanner test sheet
How to Lock/Unlock an Excel Cell Based on the Contents of Another Cell? I would like to lock a range of cells based on the contents of a single cell. In Cell G2 the user is expected to select a number or an "X" from a drop down list. Dec 03, 2019 · An external reference (also called a link) is a reference to a cell or range on a worksheet in another Excel workbook, or a reference to a defined name in another workbook. You can use Excel for the web to view external references, but you can’t create them using Excel for the web.